ExcelBanter - XLVERYHIDDEN

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - XLVERYHIDDEN (https://www.excelbanter.com/excel-programming/334454-xlveryhidden.html)

Sunil Patel

XLVERYHIDDEN

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

Bob Phillips[_6_]

XLVERYHIDDEN

Worksheets("Sheet1").Visible = xlSheetVeryHidden

and

Worksheets("Sheet1").Visible = xlSheetVisible

--

HTH

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

"Sunil Patel" wrote in message
...
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

All times are GMT +1. The time now is 05:44 AM.