PDA

View Full Version : Lock Cell Format?



doctortt
03-29-2011, 03:56 PM
Just curious. Is there a way to lock the format of a cell using VB codes and not macro? Or, is it better to just lock the cell from the GUI interface in Excel?

When the user opens this Excel program, I don't want the user to change the format of any cell. If the user accidentally changes the format and saves it, the next user who uses it will be affected.

Kenneth Hobs
03-29-2011, 05:09 PM
Not sure what you mean by vb codes and macro. They are the same.

Protect the sheet to fix the format.