View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Row height & Column width locked?

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