Where is the protection in VBA???

T

TPD

Hi.

I used VBA project to hide a worksheet using the "VeryHidden" drop dow
option. It works great in that the worksheet is hidden. There is on
problem though that is ridiculous to me. All one has to do is simpl
open up the Excel file view the control toolbox, then select view code
and the hidden sheet name is sitting right there in plain sight. Yo
then select that sheet and choose the properties window and there plai
as day is the drop down menu with the "Very hidden" characteristic
begging to be changed.

I used the password feature in there, but all that does is protec
access to the properties when you right click the sheet name. Big deal
All I had to do was then select the properties window icon and there i
all was. How can I protect the properties window from being viewed?

Anyone?

thanks!
Tod
 
B

Bob Phillips

Try protecting the workbook in the VBE. Select the project, right-click and
choose Project Properties.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top