Open another workbook with command button
Hi,
I would like to make a main page where you can choose between different pages in a data validation list. Something in the direction as shown in the picture.
Once you have chosen the page you want to visit in the list, press the command button. Then another workbook must open, on the selected page and in a specific cell.
Unavngivet.jpg
How can I make it?
Hopefully there is someone who can help me
Without a command button
This assumes that it is the same cell in every sheet
Amend the 3 constant values to match your file path, file name and the cell reference
The change in the value of the cell A1 triggers file to open
Test in attached file
Code is in sheet module
Please Login or Register to view this content.
Last edited by kev_; 02-10-2018 at 07:09 PM.
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
Using command button
Does same as previous code, only this time behind command button
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks