Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing a Hidden and Protected Workbook from a Macro??
Hi
this is no probelm. Try something like the following: sub foo() dim wks as worksheet set wks = worksheets("Data") wks.range("A1").value=12 end sub -----Original 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run a sort macro in a protected WORKBOOK | Excel Discussion (Misc queries) | |||
VBA Macro cannot see hidden workbook | Excel Discussion (Misc queries) | |||
error accessing a protected worksheet | Excel Worksheet Functions | |||
Accessing password-protected Excel wkbk from VB | Excel Programming | |||
Accessing/Clearing range in hidden workbook | Excel Programming |