jason,
I still want several of my worksheets to remain hidden.
Not a problem.
Get rid of the For..Next loop that unhides all of the worksheets
and just unhide each one that you want to.
Worksheets("yoursheetname1").Visible = True
Worksheets("yoursheetname2").Visible = True
Just make sure that you don't hide the EULA sheet until you've
made at least one other sheet visible or the macro will crash
(there always has to be at least one visible sheet)
when a worksheet is veryhidden, can Excel see the data?
Sure can.
John
"jasonsweeney " wrote in
message ...
Thanks John, this is very helpful.
One stone in the shoe...even after the user accepts the EULA, I still
want several of my worksheets to remain hidden. Is it better to also
make these sheets veryhidden, or just normal hide?
(Side question, when a worksheet is veryhidden, can Excel see the
data?, i.e. can I have the visible worksheets pull data from cells in
the veryhidden worksheet?)
---
Message posted from http://www.ExcelForum.com/