Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Protect Workbook Vs Protect Sheet
Hiii hope u are all ok. i have a problem about protect workbook.when i go to
tools menus and then point to Protection and click on the protect work book to protect workbook can't be done as it should be.. probably i don't know the proper way how to protect a workbook........ plz help me . thank u very much indeed. (inadvance) |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Protect Workbook Vs Protect Sheet
Hi there,
you can protect the workbook itself (against modification = read only, or even fully, against all access) when saving the file: file menu/ save as/ Tools (dropdown list on the panel right hand side) / settings and adding the PW hope, this helps, Regards, ANdras "Poor_pakistani" wrote: Hiii hope u are all ok. i have a problem about protect workbook.when i go to tools menus and then point to Protection and click on the protect work book to protect workbook can't be done as it should be.. probably i don't know the proper way how to protect a workbook........ plz help me . thank u very much indeed. (inadvance) |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Protect Workbook Vs Protect Sheet
There are several types of password protection.
1. Password to open the file. Can be set at FileSave AsToolsGeneral Options. 2. Password on a protected worksheet. This is set at ToolsProtectionProtect Sheet. Many functions can be disabled using this type of protection. 3. Workbook Protection password. This is set at ToolsProtectionProtect Workbook. This protects the workbook from having sheets deleted and other functions disabled. 4. VBA Project password to prevent viewers from looking at code modules. NOTE: except for File to Open protection and VBA project passwords, most forms of Excel protection are very weak and passwords can be easily cracked. Gord Dibben MS Excel MVP On Sun, 30 Apr 2006 23:47:01 -0700, Poor_pakistani wrote: Hiii hope u are all ok. i have a problem about protect workbook.when i go to tools menus and then point to Protection and click on the protect work book to protect workbook can't be done as it should be.. probably i don't know the proper way how to protect a workbook........ plz help me . thank u very much indeed. (inadvance) Gord Dibben MS Excel MVP |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Protect Workbook Vs Protect Sheet
it don't work
"ANdras" wrote: Hi there, you can protect the workbook itself (against modification = read only, or even fully, against all access) when saving the file: file menu/ save as/ Tools (dropdown list on the panel right hand side) / settings and adding the PW hope, this helps, Regards, ANdras "Poor_pakistani" wrote: Hiii hope u are all ok. i have a problem about protect workbook.when i go to tools menus and then point to Protection and click on the protect work book to protect workbook can't be done as it should be.. probably i don't know the proper way how to protect a workbook........ plz help me . thank u very much indeed. (inadvance) |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Protect Workbook Vs Protect Sheet
still it doesn't work . plzzzz i want some one to tell me how to apply
protect workbook on my workbook i need someone to tell me the procedure from a to z i do want that though i know that it protect ur sheets from delete etc. thanks hope u can understand me well this time "Gord Dibben" wrote: There are several types of password protection. 1. Password to open the file. Can be set at FileSave AsToolsGeneral Options. 2. Password on a protected worksheet. This is set at ToolsProtectionProtect Sheet. Many functions can be disabled using this type of protection. 3. Workbook Protection password. This is set at ToolsProtectionProtect Workbook. This protects the workbook from having sheets deleted and other functions disabled. 4. VBA Project password to prevent viewers from looking at code modules. NOTE: except for File to Open protection and VBA project passwords, most forms of Excel protection are very weak and passwords can be easily cracked. Gord Dibben MS Excel MVP On Sun, 30 Apr 2006 23:47:01 -0700, Poor_pakistani wrote: Hiii hope u are all ok. i have a problem about protect workbook.when i go to tools menus and then point to Protection and click on the protect work book to protect workbook can't be done as it should be.. probably i don't know the proper way how to protect a workbook........ plz help me . thank u very much indeed. (inadvance) Gord Dibben MS Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect Workbook | Excel Discussion (Misc queries) | |||
hyperlink to sheet in workbook saved as html | Excel Discussion (Misc queries) | |||
Copy sheet - Break Links to Old Workbook - Retain Formula. | Setting up and Configuration of Excel | |||
Identify repeated cell entries in multiple sheet workbook as you . | Excel Discussion (Misc queries) | |||
Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel |