allowing user to format a protected cell

  • Thread starter Thread starter Andrew
  • Start date Start date
A

Andrew

Hi

When I protect a worksheet, even when a particular cell is unlocked,
users are unable to change the font size, number of decimals in a
calculation, colour of text, bold it, change the width of the colums
etc.

Is there anyway to allow users to make these alterations, while still
protecting other (locked) cells on the same worksheet?

Thanks for your thoughts / advice

andrew.
 
If you are using xl2002/2003 then you can protect the sheet and allow users
to format cells, unfortunately this means all cells not just those unlocked.
Earlier versions do not have this feature.

I believe that you would need to dynamically unprotect the sheet, test the
cells for those you allow users to change (named ranges for example) then
protect the sheet again, all under the control of a VBA program triggered
by the change events.

Cheers
Nigel
 
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

code for Allow Insert Hyperlink 2
Allow Users to Unfreeze Panes in a Protected Workbook/Sheet 2
Password Cell Protection 1
Allow VBA code to change a locked cell?? 2
Format columns and cells in a protected sheet 2
Change cell state with protected sheet 3
Format columns & cells in a protected sheet - VBA code 2
Format Unlocked Protected Cells 0

Back
Top