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.