| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Protect / unprotect function
I used the "Review/Protect" function to protect a workbook w/mulitple
worksheets. I am trying to edit some of the worksheets but the icon on the ribbon is not available. How do I retrieve the option to the "unprotect" option? -- Thanks!! sg |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Protect / unprotect function
Tools Protection Protect Sheet
Does that do what you want to do? Regards, Ryan--- -- RyGuy "sg" wrote: I used the "Review/Protect" function to protect a workbook w/mulitple worksheets. I am trying to edit some of the worksheets but the icon on the ribbon is not available. How do I retrieve the option to the "unprotect" option? -- Thanks!! sg |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Protect / unprotect function
Hello ryguy7272...
Not really. After going back only a couple of the worksheets are protected while others are not. However, the unprotect button is unavailable. Any suggestions for both my issues? -- Thanks!! sg "ryguy7272" wrote: Tools Protection Protect Sheet Does that do what you want to do? Regards, Ryan--- -- RyGuy "sg" wrote: I used the "Review/Protect" function to protect a workbook w/mulitple worksheets. I am trying to edit some of the worksheets but the icon on the ribbon is not available. How do I retrieve the option to the "unprotect" option? -- Thanks!! sg |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Protect / unprotect function
Hummm, I'm not sure I full understand your dilemma. You say 'only a couple
of the worksheets are protected'... Maybe you can give this a try: Tools Protection Protect Workbook (or Unprotect Workbook) Regards, Ryan--- -- RyGuy "sg" wrote: Hello ryguy7272... Not really. After going back only a couple of the worksheets are protected while others are not. However, the unprotect button is unavailable. Any suggestions for both my issues? -- Thanks!! sg "ryguy7272" wrote: Tools Protection Protect Sheet Does that do what you want to do? Regards, Ryan--- -- RyGuy "sg" wrote: I used the "Review/Protect" function to protect a workbook w/mulitple worksheets. I am trying to edit some of the worksheets but the icon on the ribbon is not available. How do I retrieve the option to the "unprotect" option? -- Thanks!! sg |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect/ unprotect worksheet | Excel Discussion (Misc queries) | |||
| Protect-Unprotect all the sheets | Excel Worksheet Functions | |||
| Protect/Unprotect Worksheet | Excel Discussion (Misc queries) | |||
| Is there any way that you can protect or unprotect a group of wor. | Excel Discussion (Misc queries) | |||
| Protect/unprotect all worksheets | Excel Worksheet Functions | |||
Linear Mode
