Protect a few sheets

S

Soniya

Hi all,

I hace 10 sheets in a workbook.

out of it I have to protect five sheets in my Auto_Open
Macro
Say Sheet1, sheet4, sheet5, sheet9 and sheet 10
Hi all,

what would be the Easy coding for this rather
sheets("Sheet1").protect
EnableSelection = xlUnlockedCells
sheets("Sheet4").protect
EnableSelection = xlUnlockedCells
sheets("Sheet5").protect
EnableSelection = xlUnlockedCells


and so on..

TIA
Soniya
sheets("Sheet1").protect
 

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

EnableSelection Protecting sheet question 3
EnableSelection for all sheets 2
Phantom sheet protect 5
Run Macro on All Sheets Q 8
Protected Sheet Problem in Excel 2000 2
Cursor and Sheet Protection may09 2
Lose Cursor After Protecting Sheet 2
Help with subscript out of range error. 3

Top