access password to worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how to set up an access password to open one of the worksheet which is in the
workbook?
 
Sorry, the messege didnt go through last time.

Go to Tools-->Protection--> Protect Sheet.

Magnivy
 
Are you saying a worksheet is hidden and you want to unhide it using a password?

How did you hide the sheet?

If by Format>Sheet>Hide, you will have to Protect the Workbook with a password
to prevent anyone from unhiding the sheet.

To unhide the sheet you UnProtect the workbook and unhide the sheet.

But if you have other hidden sheets these would be available for unhiding.

If you hide the sheet by VBA code and make it xlVeryHidden then you need code to
unhide it again.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Different Passwords for different worksheets in one workbook 8
How to retrive password protected worksheet but forgot password? 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Password prompting to unhide worksheet allows temporary visibility 2
Excel Protection 2
Password Protection for Worksheets already protected 16
Is there a way that I can password protect a worksheet 3
Password protect sheet from viewing 4

Back
Top