Password protect

**Urchino** · 03-20-2012, 03:09 AM

Hi,

I tried to use the existing post to create my own about password but unable to do so.

Currently I have a Sheets("Main") and a hidden Sheets("Database") with protected password.

What i wanted to create is a macro position in Sheets("Main") to unhide Sheets("Database") and by doing so it will prompt the user to enter the password in a Input box. How should i do it?

I have something like this

Please Login or Register  to view this content.

I think i screw it up.

Thank you

Regards

**royUK** · 03-20-2012, 03:26 AM

I think you want this code added to a button

Please Login or Register  to view this content.

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste
To run the Excel VBA code:

Choose Tools | Macro | Macros
Select a macro in the list, and click the Run button

**Urchino** · 03-20-2012, 03:45 AM

Thank you. It is wonderful.

**Toonies** · 03-20-2012, 07:08 AM

Hi have a look at this

http://www.vbaexpress.com/kb/getarticle.php?kb_id=380

Many thanks

Toonies

**royUK** · 03-20-2012, 08:25 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save