| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
access password to worksheet
how to set up an access password to open one of the worksheet which is in the
workbook? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Opening Protected EXCEL worksheets to update linked data | Excel Discussion (Misc queries) | |||
| How do I get ONLY new info from 1 Worksheet to another automatical | Excel Worksheet Functions | |||
| Excel worksheet retrieving data from Access | Links and Linking in Excel | |||
| How can I password protect a worksheet from being deleted | Excel Discussion (Misc queries) | |||
| Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
Linear Mode
