xlVeryHidden

[jacqui]

Sorry bit of a basic question this...
If I set my Worksheet Visible property to xlVeryHidden so
that users cannot unhide it, am I still able to access
data on the worksheet through code? If so do I access the
information in much the same way as I usually would ie if
I have a number in cell A1 and the sheet is xlVeryHidden
is the syntax Range("A1").select still recognised.
Many thanks
Jacqui

 

[Guest]

Yes

Sub foo() ' Subroutine name credits to Fran
Worksheets("Sheet1").Visible = xlVeryHidde
Worksheets("Sheet1").Activat
Range("A1").Selec

MsgBox ActiveCell.Valu
End Su

-Brad

 

[Frank Kabel]

Hi
yes!