Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Buttons they are moving on Me
I have used this worksheet for several months, and in this sheet I have
included a couple buttons. Today when I print this sheet out , the buttons moved to another location on the sheet. Here is my code that I have used on button one: Private Sub CommandButton2_Click() Range("B3").Select ActiveWindow.ScrollRow = 2 ActiveWindow.FreezePanes = True End Sub And button two is using this code: Private Sub CommandButton3_Click() ActiveWindow.FreezePanes = False Range("A2").Select ActiveWindow.ScrollRow = 1 End Sub Can somebody tell me why these buttons just now are deciding to move after printing. Steve |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Buttons they are moving on Me
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. caldog wrote: I have used this worksheet for several months, and in this sheet I have included a couple buttons. Today when I print this sheet out , the buttons moved to another location on the sheet. Here is my code that I have used on button one: Private Sub CommandButton2_Click() Range("B3").Select ActiveWindow.ScrollRow = 2 ActiveWindow.FreezePanes = True End Sub And button two is using this code: Private Sub CommandButton3_Click() ActiveWindow.FreezePanes = False Range("A2").Select ActiveWindow.ScrollRow = 1 End Sub Can somebody tell me why these buttons just now are deciding to move after printing. Steve -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Buttons they are moving on Me
Thanks Dave,
It works for me. BTW I just download those updates this morning, so that explains to me why it started moving. Steve "Dave Peterson" wrote: 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. caldog wrote: I have used this worksheet for several months, and in this sheet I have included a couple buttons. Today when I print this sheet out , the buttons moved to another location on the sheet. Here is my code that I have used on button one: Private Sub CommandButton2_Click() Range("B3").Select ActiveWindow.ScrollRow = 2 ActiveWindow.FreezePanes = True End Sub And button two is using this code: Private Sub CommandButton3_Click() ActiveWindow.FreezePanes = False Range("A2").Select ActiveWindow.ScrollRow = 1 End Sub Can somebody tell me why these buttons just now are deciding to move after printing. Steve -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Buttons they are moving on Me
Dave Peterson wrote:
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. I have a problem with buttons disappearing altogether (though just one at a time) in Excel X for Mac. Has anyone else experienced this? -- Gordon Rainsford London UK |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Buttons they are moving on Me
If you don't get a good response here, you may want to post in:
microsoft.public.mac.office.excel Gordon Rainsford wrote: Dave Peterson wrote: 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. I have a problem with buttons disappearing altogether (though just one at a time) in Excel X for Mac. Has anyone else experienced this? -- Gordon Rainsford London UK -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving data between sheets using buttons | Excel Worksheet Functions | |||
Moving Buttons | Excel Discussion (Misc queries) | |||
Sort without moving buttons | Excel Discussion (Misc queries) | |||
Command buttons moving in Excel | Excel Programming | |||
keeping buttons from moving | Excel Programming |