| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protect selected sheet(s)
Hi
I've written some code that is supposed to protect a group of selected sheets but I get an error 1004: Method 'Protect' of object '_Worksheet' failed. Is this because you can only protect a sheet when there is only one sheet selected, in that the protection of sheet can not be performed when multiple sheets are selected. If this is the case then I'll store the sheet indexes in an array and protect them one by one and then reselect them once done. TIA KM |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Protect selected sheet(s)
Yes, protect sheet by sheet.
-- Regards, Tom Ogilvy "Kevin McCartney" wrote: Hi I've written some code that is supposed to protect a group of selected sheets but I get an error 1004: Method 'Protect' of object '_Worksheet' failed. Is this because you can only protect a sheet when there is only one sheet selected, in that the protection of sheet can not be performed when multiple sheets are selected. If this is the case then I'll store the sheet indexes in an array and protect them one by one and then reselect them once done. TIA KM |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect selected column | Excel Discussion (Misc queries) | |||
| How do I protect selected cells on my worksheet? | Setting up and Configuration of Excel | |||
| How do I protect selected cells on my worksheet? | Setting up and Configuration of Excel | |||
| how do i make it so that when a sheat is selected either via link or tab, that xlLastCell is selected. the last on the sheet. | Excel Worksheet Functions | |||
| Lock and protect cells without protect the sheet | Excel Programming | |||
Linear Mode
