XLVERYHIDDEN

S

Sunil Patel

How do you make a sheet e.g "details" xlveryhidden=true, and then visible
if password entered correctly

keep getting subscript out of range error

Thanks

Sunil
 
B

Bob Phillips

Worksheets("Sheet1").Visible = xlSheetVeryHidden

and

Worksheets("Sheet1").Visible = xlSheetVisible

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with ".Visible" sheet property 2
Sheets - xlVeryHidden 2
Stop sheet showing when Using Datapig's Force Users to enable macr 2
macro to auto-veryhide 5
Modify data on a hidden sheet? 5
Workbook open code to do 2 things 1
Read cell value of xlVeryHidden sheet 2
Filtered view of Visio Chart 0

Top