Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Stryder
 
Posts: n/a
Default Radio buttons moving when spreadsheet is viewed on other systems

Hello,

I am using Office 2003 with service pack 2.

I have created a for using excel. The form contains several radio buttons
and check mark objects. When the for is viewed on other systems, some of the
text in the objects are cut off.

It seems that when the spreadsheet is viewed on other systems the column
sizes are changing. So, the objects, both radio buttons and check marks, are
resized. I have changed the format control to both "Move but don't size" and
Don't move or size" the problem still exists.

I have two questions:

1. Does anyone know why the columns get resized? and is there any way to
prevent that?

2. Is there any way to stop objects from moving around and getting resized?

Thank you in advance for your assistance.
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Radio buttons moving when spreadsheet is viewed on other systems

There's no macros running that changes the columnwidths, right?

There were a bunch of posts that complained about this happening in xl97--I
don't recall seeing complaints with newer versions.

Some posters say that upgrading to xl97SR2 helps. But others have said that it
had no effect.

If your users are not running xl97SR2, you may want to suggest it.

Stryder wrote:

Hello,

I am using Office 2003 with service pack 2.

I have created a for using excel. The form contains several radio buttons
and check mark objects. When the for is viewed on other systems, some of the
text in the objects are cut off.

It seems that when the spreadsheet is viewed on other systems the column
sizes are changing. So, the objects, both radio buttons and check marks, are
resized. I have changed the format control to both "Move but don't size" and
Don't move or size" the problem still exists.

I have two questions:

1. Does anyone know why the columns get resized? and is there any way to
prevent that?

2. Is there any way to stop objects from moving around and getting resized?

Thank you in advance for your assistance.


--

Dave Peterson
Reply
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 stop radio buttons moving left after Printing KoLM#s Excel Discussion (Misc queries) 5 July 19th 07 03:42 PM
Moving Buttons stevepain Excel Discussion (Misc queries) 4 December 22nd 05 08:01 PM
Moving Around a Blank Spreadsheet carl Excel Worksheet Functions 1 September 15th 05 06:54 PM
Sort without moving buttons David P. Excel Discussion (Misc queries) 1 July 3rd 05 12:36 AM
How do I stop VB buttons from moving in Excel after printing etcrv Excel Discussion (Misc queries) 1 May 19th 05 06:14 PM


All times are GMT +1. The time now is 02:47 AM.

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

About Us

"It's about Microsoft Excel"