Thread: Accessing a Hidden and Protected Workbook from a Macro??
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
djbasumatari djbasumatari is offline
external usenet poster
  
Posts: 1
Default Accessing a Hidden and Protected Workbook from a Macro??
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 pleas
help me.

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

Regards
D.J. Basumatar

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

Reply With QuoteReply With Quote