View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gene Gene is offline
external usenet poster
 
Posts: 100
Default protect sheet but column width changes

after protecting the worksheet (tools protection protect sheet) I email
the document and when opened the column widths and heights are slightly
different.

Sometimes this causes #### in the cells because of the width change rather
than the numbers (12345) that I can see on the computer that generated the
document. I verified the receiver of the document displays the same font and
font size that I originally created.

This happens when received on different computers/screens. Some are using
the same Excel 2002 SP3 but have different screens.

I use Excel 2002 SP3

How can I prevent cells from from changing size after emailing them so to
prevent #### from displaying? Again the originating computer can view all
the numbers but some others only see #### in a few cells.

As always thanks for the expert assistance!
--
Gene