View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
miek miek is offline
external usenet poster
 
Posts: 39
Default VBA visible property

The worksheet "Blank time" visible property is set to xlsheetveryhidden.
The worksheet protection is password protected.
The workbook protection is password protected.

I have the following code:

lDate = Application.InputBox("Enter a date to begin with. Format: mm/dd/yy")
If LCase(lDate) = "false" Then Exit Sub
Worksheets("Blank time").Visible = True ' Runtime error 1004 when pw
protected
Worksheets("Blank time").Select

I get a run time error 1004 on the .visible line when the sheet/workbook is
pass protected. How can I get around this?
thanks