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???

Stephen C wrote:

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.

--

Dave Peterson