access password to worksheet
 

how to set up an access password to open one of the worksheet which is in the
workbook?

access password to worksheet
 

Tools -- Protection -- Protect Sheet

"mrt" wrote:

how to set up an access password to open one of the worksheet which is in the
workbook?

access password to worksheet
 

Sorry, the messege didnt go through last time.

Go to Tools--Protection-- Protect Sheet.

Magnivy

"mrt" wrote:

how to set up an access password to open one of the worksheet which is in the
workbook?

access password to worksheet
 

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

How did you hide the sheet?

If by FormatSheetHide, 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

On Fri, 1 Sep 2006 03:56:01 -0700, mrt wrote:

how to set up an access password to open one of the worksheet which is in the
workbook?