ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Radio buttons moving when spreadsheet is viewed on other systems (https://www.excelbanter.com/excel-discussion-misc-queries/70588-radio-buttons-moving-when-spreadsheet-viewed-other-systems.html)

Stryder

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.

Dave Peterson

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


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com