Protect VBA

[tiredofit]

VBA code can be protected with a password (although it can be hacked using third party software).

Regardless, adding a password does NOT prevent access to the vb editor.

My workbook contains very hidden worksheets, so the only way to unhide them is using code.

But even if the code is password protected, users can still open the vb editor, open the immediate window and unhide worksheets using:

myhiddensheet.Visible = xlSheetVisible

Is there any way to prevent users from doing this?

I came across code to stop users opening the vb editor but to get round that, all they needed to do is disable macros (which disables the workbook_open event) and then open the vb editor.

Thanks

 

[RedBeard]

No, Excel has no security. If you want to open something it is always trivial.

 

[tiredofit]

What about Excel DNA?

Does that require .Net knowledge?

 

[RoryA]

If you're willing to pay for other tools, you could try Unviewable+

 

[tiredofit]

I'll happily pay but will my company,

 

[Jaafar Tribak]

Have you thought about password protecting the workbook structure via Revision>Protect Workbook ?