LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I change column width in the middle of an Excel sheet? Malcolm Excel Discussion (Misc queries) 6 August 13th 09 10:40 AM
How to retain column width and formulas in copying a sheet smich Excel Discussion (Misc queries) 3 January 15th 09 03:55 PM
Change Cell Width WITHOUT changing Column width dww701 Excel Discussion (Misc queries) 1 January 12th 09 10:52 PM
I can't able to protect a sheet if it having any column / rows gro sudarsan Excel Discussion (Misc queries) 4 October 19th 08 01:51 AM
I want to change the column width on a spread sheet? Celia[_2_] Excel Worksheet Functions 1 July 13th 07 09:10 PM


All times are GMT +1. The time now is 02:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"