Excel. Change Font in locked Cells?

  leeknight67 14:02 21 Jun 2008
Locked

I Have Locked cells that I want to protect so that others cant change the formulas. But I want them to be able to change the Font colour and the option the bold the font.

Any ideas on how to do this

Thanks in advance

Lee

  crosstrainer 15:00 21 Jun 2008

If you have protected the cells, and not the entire worksheet, you should still be able to change the font and colour.

Problem is that the chabges will be reflected across the entire workbook.

What version of Ecel are you using?

  crosstrainer 15:03 21 Jun 2008

Some info here: Seems that if you protect a cell then you can't change anything...You could in good old office 97 pro!


click here

  VoG II 15:17 21 Jun 2008

I don't think this is possible but what version of Excel are you using. There are ways of preventing changes without protecting the worksheet like this: Right click the sheet tab and select View Code then paste in


Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("A1:C10")) Is Nothing Then Exit Sub
Application.EnableEvents = False
Application.Undo
Application.EnableEvents = True
End Sub



Then click the X to exit the VBE. Now if you try to change anything in the range A1:C10 it will be undone.

  VoG II 15:22 21 Jun 2008

In didn't explain properly. If you do not protect the sheet but use the above code, users can change the formatting but not the values in the designated range.

  leeknight67 15:57 21 Jun 2008

Excel 2003

  VoG II 21:43 21 Jun 2008

Did you try the code?

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

28 astuces pour profiter au mieux de votre iPhone