ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I stop VB buttons from moving in Excel after printing (https://www.excelbanter.com/excel-discussion-misc-queries/26860-how-do-i-stop-vbulletin-buttons-moving-excel-after-printing.html)

etcrv

How do I stop VB buttons from moving in Excel after printing
 
VB buttons work fine during use but if I print the sheet with one or more on
it the button(s) move to the left of the page and stay there. If more than
one choice the buttons stack on top of each other. I can go back intothe VB
editor and move them back but that seems to be a major waste of time.
If I remembered to save the file first I can close and reopen the
spreadsheets and everything is fine.

Dave Peterson

xl2002???

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 for her in all her
workbooks.

etcrv wrote:

VB buttons work fine during use but if I print the sheet with one or more on
it the button(s) move to the left of the page and stay there. If more than
one choice the buttons stack on top of each other. I can go back intothe VB
editor and move them back but that seems to be a major waste of time.
If I remembered to save the file first I can close and reopen the
spreadsheets and everything is fine.


--

Dave Peterson


All times are GMT +1. The time now is 08:43 AM.

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