ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Moving OptionButtons (https://www.excelbanter.com/excel-discussion-misc-queries/75659-moving-optionbuttons.html)

MarkyB

Moving OptionButtons
 
I have some OptionButtons on a spreadsheet that, as far as I can tell, has
all the relevent properties set so that they do not move. Unfortunately, when
you print (or print preview) the spreadsheet, they realign themselves to the
left of the sheet.

Can anyone give me a reason/workaround/fix for this?

Using Windows XP Pro (SP2) and Excel 2002 (SP3).

Thanks,

Mark

Dave Peterson

Moving OptionButtons
 
http://support.microsoft.com/default...b;EN-US;838910
Controls move to the left of the worksheet in Microsoft Excel 2002

But Jim Rech recently posted this:
This article is now obsolete. Since the 10/12/2004 security patch
there is no need to get a hotfix (although this article does not directly
mention this fix, it's in there).

http://support.microsoft.com/default...b;en-us;832332

But Myrna Larson (and others) posted that it didn't work in all workbooks.

MarkyB wrote:

I have some OptionButtons on a spreadsheet that, as far as I can tell, has
all the relevent properties set so that they do not move. Unfortunately, when
you print (or print preview) the spreadsheet, they realign themselves to the
left of the sheet.

Can anyone give me a reason/workaround/fix for this?

Using Windows XP Pro (SP2) and Excel 2002 (SP3).

Thanks,

Mark


--

Dave Peterson

MarkyB

Moving OptionButtons
 
Thanks Dave, now works as it should.

"Dave Peterson" wrote:

http://support.microsoft.com/default...b;EN-US;838910
Controls move to the left of the worksheet in Microsoft Excel 2002

But Jim Rech recently posted this:
This article is now obsolete. Since the 10/12/2004 security patch
there is no need to get a hotfix (although this article does not directly
mention this fix, it's in there).

http://support.microsoft.com/default...b;en-us;832332

But Myrna Larson (and others) posted that it didn't work in all workbooks.

MarkyB wrote:

I have some OptionButtons on a spreadsheet that, as far as I can tell, has
all the relevent properties set so that they do not move. Unfortunately, when
you print (or print preview) the spreadsheet, they realign themselves to the
left of the sheet.

Can anyone give me a reason/workaround/fix for this?

Using Windows XP Pro (SP2) and Excel 2002 (SP3).

Thanks,

Mark


--

Dave Peterson



All times are GMT +1. The time now is 08:18 PM.

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