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

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