macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need a macro command to unprotect cells A6:O6. I don't won't to unprotect
the whole Sheet could someone help me ?

Thank Ken
 
Cells are locked or unlocked - but to change that setting you have to
unprotect the worksheet

Activesheet.Unprotect Password:="ABC"
cells.Locked = True
Range("A6:O6").Locked = False
Activesheet.Protect Password:="ABC"
 

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

Macro to Unprotect save worksheet and protect it again. 2
Copying in sheet with protection with the use of a macro 5
Macro can not unprotect a sheet in a shared workbook 4
Multiple tabs 3
Protecting sheet in a macro doesn't work 1
Protecting worksheet. 1
Running Macros in a Shared File 2
Simple workbook Protect 2

Back
Top