On the attached workbook I want to have a cell where you can type a sheet number and it takes you to that sheet. My original file has over 100 worksheets and it would be easier for them to have a cell as described as opposed to a Hyperlink where a none user may not be able to follow.
I have already submitted a similar question without adding the attached file
It is a protected file.... need password to open it.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
Just enter a reference in the Names box, left of the formula bar, e.g., Sheet2!A1
Entia non sunt multiplicanda sine necessitate
My mistake password isOriginally Posted by Arkadi
keane11
The user would not recognise this from one use to the next
I don't know what that means; if they don't know the names of the sheets, how would they know what to type in the cell?
Are you really using Excel 2003? It makes a big difference on how this will be implemented.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
On which sheet would this cell be? or same cell on every sheet?
Here is a workbook that will work with 2003. Run the macro MakeLinks and it populates the Index sheet with sheet names. Clicking on a sheet name unhides and activates that sheet.
Attached is the Excel 2010 or later version. I can't seem to upload the XLS version.
Last edited by dflak; 03-29-2017 at 02:10 PM.
Here is the code.
Selection Change Event on Index Sheet Module
MakeLinks in a regular module
Please Login or Register to view this content.
Please Login or Register to view this content.
To do what you described, put this in the "ThisWorkbook" module, not a normal module. Also, you didn't say how to handle hidden sheets so I took a guess.
Please Login or Register to view this content.
The user has little to no knowledge of Excel and would not remember to put cursor in Go To box to type in the sheet number
Sorry but this is where I came unstuck when someone else helped me - I do not know how to "put this in the ThisWorkbook" module. My limited knowledge is to select Developer and Visual Basic and copy and paste codes there.To do what you described, put this in the "ThisWorkbook" module, not a normal module. Also, you didn't say how to handle hidden sheets so I took a guess.
Please Login or Register to view this content.
Last edited by fizzwolf; 04-01-2017 at 04:11 AM.
Alt-F11 would bring you to VBA editor. There you have a section on the left where you would see a list of the sheets, and also "ThisWorkbook". Double click ThisWorkbook and then paste the code.
Thank you perfect
Please mark the thread as solved if you are satisfied? Thanks in advance for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks