Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel Goto?
- Thread starter Maine
- Start date
You could have multiple buttons that take you to each worksheet in the same file. The way to do it is:
1. VIEW->TOOLBARS->FORMS
2. Click on the BUTTON icon and create a button
3. In the "Assign Macro" dialogue box, enter a macro name
4. Click RECORD
5. Move to the desired worksheet using your mouse
6. Stop recording
7. Change the text on the button if you want to
Thats it. Follow the steps above as many times as you want to.
1. VIEW->TOOLBARS->FORMS
2. Click on the BUTTON icon and create a button
3. In the "Assign Macro" dialogue box, enter a macro name
4. Click RECORD
5. Move to the desired worksheet using your mouse
6. Stop recording
7. Change the text on the button if you want to
Thats it. Follow the steps above as many times as you want to.
- Thread starter
- #4
Obviously the file size will increase, but because you are only moving from one sheet to another, the macros are not huge.
This should not adversly affect the file size, so even with 20 buttons, you should only see an increase of a few K's.
This should not adversly affect the file size, so even with 20 buttons, you should only see an increase of a few K's.
- Status