Excel. Change Font in locked Cells?

  leeknight67 14:02 21 Jun 08
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 08

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 08

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 08

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 08

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 08

Excel 2003

  VoG II 21:43 21 Jun 08

Did you try the code?

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

Intel Coffee Lake 8th-gen Core processors release date rumours

1995-2015: How technology has changed the world in 20 years

Apple MacBook Pro with Touch Bar review

Best iPhone games 2017 | Best iPad games 2017: 162 fantastic iOS games that you need to play right…