Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Dave Peterson
 
Posts: n/a
Default

Many users have their own personal macros that can make worksheets visible.

If you want to make it a little more difficult, then when you protect the
workbook:

Tools|Protection|protect workbook
make sure you check that Structure checkbox.

But there is code that is freely available that can remove the worksheet
protection and workbook protection in a matter of moments.

The VBA project protection won't even come into play for this.

And protecting a worksheet doesn't affect the visibility of that worksheet.



Marc wrote:

The biggest difference is whether the user can see (and show) the

worksheet via
the:
Format|sheet|Unhide dialog


If I have Very Hidden sheets, and protect sheet, workbook and VBA project
with password, and someone unprotect sheet, he has to unprotect also VBA
project so that he can see sheets?

Thanks


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 04:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"