Hiding and unhiding
Posted by Deb on June 06, 2000 9:47 PM
I wrote a macro that hides all the sheets in my open work books. I am not very good at macros yet though so i use
If WorkbookIsOpen("Marta.xls") Then
Workbooks("Marta.xls").Sheets("Scrap").Visible = False
Workbooks("Marta.xls").Sheets("Final").Visible = False
end if
and name all the shhets i want to hide and unhide.
now i would like to add something to make make sure that the firt sheet is always opened when i unhide them. The first sheet is always named "summary"
any suggestions