I am attempting to run a macro that unhides a sheet. The issues is that the workbook contains 5 worksheets (let's call them Sheet1-Sheet5) that may be needed, but I only want 1 unhidden at a time.
If there is a macro to hides them one at a time as well that would be brilliant.
Cheers,
C
You can only unhide the sheets, you can't pause the macro between (un)hiding.
What exactly do you mean?
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Maybe
VBA Noob
Please Login or Register to view this content.
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
Try this, it will unhide each sheet in turn. You must start with all sheets but one hidden
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