Formatting unlocked cells on protected sheet

  • Thread starter Thread starter Lee Schipper
  • Start date Start date
L

Lee Schipper

After protecting my sheet, I can enter data into unlocked cells, but I
cannot change the formatting for those same cells. (I need to be able to
adjust the decimal places.)

Is it possible to protect a sheet, but still allow formatting to be changed
on unlocked cells?

Note: I have considered writing VBA code that unprotected the sheet, updated
the cell format, then re-protected the sheet, but this won't work because
there is no way for the VBA code to know the password originally used to
protect the sheet.

TIA!
Lee
 
If you have xl2002 or later you can.

In earlier versions, there is no support for this.
 

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

Returned position address on protected sheet 7
BeforeDoubleClick on Protected Sheet 2
Modifying a locked/protected sheet 3
Disable/enable or lock/unlock cells in VBA dependent on other cells values 2
Format columns and cells in a protected sheet 2
Format columns & cells in a protected sheet - VBA code 2
Protected Cell Problems 2
code for Allow Insert Hyperlink 2

Back
Top