ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Option Buttons move after placing on sheet (https://www.excelbanter.com/excel-worksheet-functions/9439-option-buttons-move-after-placing-sheet.html)

james549

Option Buttons move after placing on sheet
 
I'v placed option buttons on various locations on my worksheet. They keep
moving around when I go to a different sheet then come back. Covering
important cells. I move them back to the desired location, come back to the
worksheet to find they have moved again. How can I fix them to stay in one
location on my sheet?

Dave Peterson

Any chance you're printing (or print previewing)?

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.

james549 wrote:

I'v placed option buttons on various locations on my worksheet. They keep
moving around when I go to a different sheet then come back. Covering
important cells. I move them back to the desired location, come back to the
worksheet to find they have moved again. How can I fix them to stay in one
location on my sheet?


--

Dave Peterson

james549

No Not printing or print previewing. Happens just by going to different
sheets in the workbook.

"Dave Peterson" wrote:

Any chance you're printing (or print previewing)?

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.

james549 wrote:

I'v placed option buttons on various locations on my worksheet. They keep
moving around when I go to a different sheet then come back. Covering
important cells. I move them back to the desired location, come back to the
worksheet to find they have moved again. How can I fix them to stay in one
location on my sheet?


--

Dave Peterson



All times are GMT +1. The time now is 07:12 PM.

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