Password Workbook Protection in Macros

[Andy Pilkington]

Hi,

I want to be able to protect and unprotect workbooks with a password using macros so that the casual user cannot unhide or hide worksheets without the password. The aim is that only worksheets unhidden by macro control should be available to the user.

Is this possible?

Thanks,
AP

 

[mikerickson]

This is one way.

How to VeryHidden worksheets and display them with a password

Hello, everyone, I love this excel so much that he can't put it into words. Macros, I adore them. The truth is that I searched in many sites, but very rarely there is a macro that is 100% consistent with what the user needs. I could not find for my needs and therefore I ask you for help. Here's...

www.mrexcel.com

But, Excel is not secure. I see too many (IMO) people on this site fuss and fiddle with Excel security options that are, ultimatly, not secure.
Making it hard for friendly users to make an error is one thing, bu keeping bad actors out is not what Excel does. On Excel, one should spend a minimum of one's time on access control.

 

[Andy Pilkington]

Thanks for this Mike. I accept that clever Excel users will be able to break the code but I just want enough to put the casual curious user off.

Thanks,
AP