COmmand button requiring password, if password ok, unhide sheet.

**galvinpaddy** · 07-04-2012, 05:47 AM

Good morning happy campers,

I am looking for a code that will unhide a sheet.

workbook contains 2 sheets

Sheet1
Sheet2

At the point of creating, Sheet2 is hidden from veiw, to be opened by another party.
Sheet1 contains a button, that asks for password, if the password is correct, Sheet2 now becomes visible.

Kind regards in advance

galvinpaddy

**smuzoen** · 07-04-2012, 06:19 AM

The first thing to understand is that Excel Security is VERY poor. That being said for the average user this may be sufficient. I have written some code and password protected the code in the VB editor - the password is "password" - this will let you see the code - if the code is password protected the average user will not be able to see the code therefore they cannot see the password hidden in the code.
I have added a button to sheet 1 that opens an Inputbox - it asks for a password - the password is "password". If the user enters the correct password then Sheet2 is made visible. The user will not be able to unhide the worksheet.
When the workbook opens it hides sheet2 if it is visible and on closing the workbook it checks to see if sheet 2 is visible and if it is it will hide the sheet prior to the workbook being closed. You need to understand this is easy to crack however as I say for the average user it will probably be sufficient.
In the workbook code

Please Login or Register  to view this content.

In a module

Please Login or Register  to view this content.

See attached workbook. Remember Excel security is very poor!!!!

**galvinpaddy** · 07-04-2012, 07:13 AM

Hi Smuzoen,

Thanks for that, it works a treat.
In regards to the security aspect - this request isnt to prevent a user deliberately editing sheet2. I aim to capture info on sheet1 at point of production, with another user, who will gather the info from sheet2, at present we have temporary staff who, through lack of knowledge/experience in Excel tend to click random things and delete info to cover their mistake

so imply put, to avoid the 'Sorry, didnt mean to do that' line i hear so often!

Again, many thanks for you input, very appreciated!
galvinpaddy

**smuzoen** · 07-04-2012, 07:16 AM

No problem. I was unsure if you were after a secure method for some confidential information. Some people think that Excel is secure however it is far from being secure. If you have any problems or questions just ask. Glad I could help.