Accessing a Hidden and Protected Workbook from a Macro??

[djbasumatari]

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

 

[Rob van Gelder]

Even if it's hidden, you can still do stuff with it.

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

 

[Frank Kabel]

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