Unprotecting Cells in a Protected Worksheet

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

Guest

I have a multi worksheet workbook. Most of the workbook is protected, but I
have isolated cells that I want to unprotect becasue they represent variables
for "what if" scenarios. How do I do it?
 
Hi
before protecting the sheet select these cells and goto 'Format - Cells -
Protection' and uncheck 'Locked'
 
IT WORKED! Thank you very much!

Frank Kabel said:
Hi
before protecting the sheet select these cells and goto 'Format - Cells -
Protection' and uncheck 'Locked'
Click to expand...
 
You must log in or register to reply here.

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

Excel Protection 2
Protect and Unprotect all worksheets with macro 2
Qualifying permissions in protect unprotect macro. 3
Code to format cells on several worksheets 2
Unable to unprotect an Excel Worksheet 2
Can't access cells 2
Protection on Worksheets 5
Unprotecting worksheets 2

Back
Top