Yes. You can either use a button to open the file you desire (record a macro
of you doing said act, then assign macro to button) or you could just create
a hyperlink, which does the same thing.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"cregs" wrote:

Hi

I need to create 1 worksheet that will have command buttons that will allow
the user to click on these buttons, however these buttons will link to
different worksheets ie top clients worksheet and top callers worksheet, etc,
is it possible to do this without putting all the sheets in 1 main worksheet?

any help would be appreciated

thanks