Protect selected sheet(s)

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Protect multiple selected sheets? 6
Array code only works on selected sheet 14
Add New Sheet when Multiple Sheets are Selected 2
I protect sheet - Macro will not run now 7
Protect worksheet - do not allow select cells 2
Protect template worksheet 2
Protecting sheet in a macro doesn't work 1
Problem referring to a particular sheet in VBA 5

Top