Thread: Accessing a Hidden and Protected Workbook from a Macro??
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rob van Gelder[_4_] Rob van Gelder[_4_] is offline
external usenet poster
  
Posts: 1,236
Default Accessing a Hidden and Protected Workbook from a Macro??
Even if it's hidden, you can still do stuff with it.

Sub test()
MsgBox Worksheets("Sheet1").Range("A1").Value
End Sub


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"djbasumatari " wrote in
message ...
I have the following issue -

1) Hide the "Data" worksheet
2) Now protect the workbook with a password

Now from a macro, how do I access this "Data" worksheet. Someone please
help me.

Basically I don't want other users to view the Data worksheet but want
to access this work sheet from a macro.

Regards
D.J. Basumatari


---
Message posted from http://www.ExcelForum.com/



Reply With QuoteReply With Quote