Where is the protection in VBA???
 

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

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

Where is the protection in VBA???
 

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)

"TPD " wrote in message
...
Hi.

I used VBA project to hide a worksheet using the "VeryHidden" drop down
option. It works great in that the worksheet is hidden. There is one
problem though that is ridiculous to me. All one has to do is simply
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. You
then select that sheet and choose the properties window and there plain
as day is the drop down menu with the "Very hidden" characteristics
begging to be changed.

I used the password feature in there, but all that does is protect
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 it
all was. How can I protect the properties window from being viewed?

Anyone?

thanks!
Todd


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