PDA

View Full Version : Solved: Hidden Worksheets



chem101
10-19-2010, 09:25 AM
Hello Everyone,

Can VBA code work on worksheets that are hidden? Do you have to right code that unhides a sheet before an event then have the code hide the sheet again? How do I access the 'Very Hidden' feature in the VBE?

Thank you very much for all of your help!!

mbarron
10-19-2010, 12:36 PM
Can VBA code work on worksheets that are hidden?
You can manipulate hidden worksheets as if they were visible. It is the same as working on a worksheet that is not the active sheet. The are some things you would have to unhide and activate the sheet. One that comes to mind is doing a 'Freeze Pane'.


How do I access the 'Very Hidden' feature in the VBE?
To make a sheet Very Hidden
Worksheets(1).Visible = xlVeryHidden
or
Worksheets(1).Visible = 2

chem101
10-19-2010, 12:43 PM
Thank you very much!!