ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to link different worksheets into the 1 menu on a septerate sh (https://www.excelbanter.com/excel-worksheet-functions/234593-how-link-different-worksheets-into-1-menu-septerate-sh.html)

cregs

How to link different worksheets into the 1 menu on a septerate sh
 
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

Luke M

How to link different worksheets into the 1 menu on a septerate sh
 
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



All times are GMT +1. The time now is 07:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com