Changing between pages in Excel


Posted by Killerkris on December 04, 2000 11:38 AM

Hi could anyone help me as this is the final part of a school project and everything is working apart from this: I cannot get a macro to switch to a hidden page. This is as the system i have made was meant to be protected by this system as i already have a very basic password program implimented etc. Any help appreciated. Just copy and paste the code here if thats ok. I was using sheets.("sheetname").Select before but this doesnt work. Any help/suggestions very welcome

KK



Posted by Ivan Moala on December 04, 2000 7:15 PM


Sheets("YourSheetNameHere").Visible = True


Ivan