How do I make a cell on a spreadsheet take me to the named sheet. I.E. I have a workbook with 100+ worksheets named numerically and want a cell within each individual sheet where I type another sheet' number that takes me to that sheet?
How do I make a cell on a spreadsheet take me to the named sheet. I.E. I have a workbook with 100+ worksheets named numerically and want a cell within each individual sheet where I type another sheet' number that takes me to that sheet?
Try this.....
Place the following code on ThisWorkbook Module and as per the code if you input a number in cell A1 of any sheet, the relevant sheet as per the number entered would be activated.
For details, refer to the attached.Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Can I get this module to work alongside I already have running on the said workbook
Do you mean you already have a code on ThisWorkbook Module? If yes, which event is being triggered?
Remember you can have only one occurrence of specific event on Sheet or ThisWorkbook Module. And if you already have a code for Workbook_SheetChange, you will need to incorporate the proposed code in the existing code.
And if there is no code for Workbook_SheetChange on ThisWorkbook Module, you can just copy the proposed code into that module and it will work fine.
I am not as advanced in Excel as you may think - I cannot get the code to work in my workbook or understand how I make a particular cell the active cell for typing the desired sheet number?
Change it here...
If Target.Address(0, 0) = "A1" Then
Thank you once again for your quick reply - Once I copy the code onto the module within Developer how do I run it and do I have to change anything within Excel to allow it to run?
You need to place this code on ThisWorkbook Module.
And once the code is there, you don't need to do anything to run the code. It's a change event code so that when you input a number in the cell A1 (maybe different in your code), the code will be triggered automatically and the relevant sheet will be activated if the sheet with than name exists in the workbook.
For more details, you may see the code in the file I uploaded in post#2.
I am still at a loss?? My workbook is not called ThisWorkbook Module and I don't know how to enter the code into the workbook I am using or get to anything remotely like ThisWorkbook Module within my workbook.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks