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