Row height & Column width locked?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to prevent the row height and column width from being changed
in an unprotected worksheet?

I know you can make the cells unlocked and protect the sheet but this then
stops the users from changing the format of the cell.

If there is not a simple solution in excel can it be done in vba code as a
worksheet change event?

I am using excel 2000.

Any help will be appreciated.
 
I don't think so.

Maybe you could reapply the column widths each time anything changes? Or when
the workbook is opened or sometime???
 
Back
Top