LinkBack URL
About LinkBacks
I have this code:
Keep getting error messages... Basically if the "1" is chosen from the drop down box I would like to open "Sheet1" and so on and so forth...HTML Code:
I have this code:
Keep getting error messages... Basically if the "1" is chosen from the drop down box I would like to open "Sheet1" and so on and so forth...HTML Code:
Last edited by jgomez; 02-04-2013 at 11:22 AM.
try this
Please Login or Register to view this content.
Last edited by john55; 02-04-2013 at 12:05 AM.
Regards, John55
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
...enjoy -funny parrots-
As far as I recall, you must have at least one sheet visible. So, you need to ensure that you make the sheet you want to see visible before you make the others hidden. Use ScreenUpdating=False to hide the transition (a little)
You might need to re-sequence John’s code or it might fail.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
TMS, yes, you're right, he needs to have at least one sheet visible, maybe that sheet where the combobox is, then he can hide/unhide therest of his sheets!
Thank you both, yes the combobox was a seperate sheet from one and two.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks