Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving Buttons
Hi all, Fairly minor, but niggly point here. I am using Excel 2002, and have got some control box buttons on a couple of worksheets that run macros. Everytime I print, or print preview the worksheet, the button moves from it's location on the sheet and obscures some of the data. The button is set such that it is not printed, however, it is annoying me that it keeps moving! Any suggestions? Merry Christmas everyone! Steve -- stevepain ------------------------------------------------------------------------ stevepain's Profile: http://www.excelforum.com/member.php...o&userid=21759 View this thread: http://www.excelforum.com/showthread...hreadid=495477 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving Buttons
See if this helps
http://support.microsoft.com/d*efault.aspx?kbid=838910 Controls move to the left of the worksheet in Microsoft Excel 2002 -- HTH Bob Phillips (remove nothere from email address if mailing direct) "stevepain" wrote in message ... Hi all, Fairly minor, but niggly point here. I am using Excel 2002, and have got some control box buttons on a couple of worksheets that run macros. Everytime I print, or print preview the worksheet, the button moves from it's location on the sheet and obscures some of the data. The button is set such that it is not printed, however, it is annoying me that it keeps moving! Any suggestions? Merry Christmas everyone! Steve -- stevepain ------------------------------------------------------------------------ stevepain's Profile: http://www.excelforum.com/member.php...o&userid=21759 View this thread: http://www.excelforum.com/showthread...hreadid=495477 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving Buttons
Hi Stevepain!
try this: Right click on the button -- Format Control -- Properties Tab -- and select the option button "Don´t move or size with cells" this should solve this problem! or if you don´t need to print the button you can uncheck the checkbox "Print object" at this same way! i hope this tip can help you! PEdro "stevepain" wrote: Hi all, Fairly minor, but niggly point here. I am using Excel 2002, and have got some control box buttons on a couple of worksheets that run macros. Everytime I print, or print preview the worksheet, the button moves from it's location on the sheet and obscures some of the data. The button is set such that it is not printed, however, it is annoying me that it keeps moving! Any suggestions? Merry Christmas everyone! Steve -- stevepain ------------------------------------------------------------------------ stevepain's Profile: http://www.excelforum.com/member.php...o&userid=21759 View this thread: http://www.excelforum.com/showthread...hreadid=495477 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving Buttons
Thanks for the input guys. Pedro - I tried your suggestion, and unfortunately it still appears to happen. Bob - unfortunately I cannot get your link to open - can you tell me how you reached that page,a dn perhaps I can navigate through the Microsoft support website myself? -- stevepain ------------------------------------------------------------------------ stevepain's Profile: http://www.excelforum.com/member.php...o&userid=21759 View this thread: http://www.excelforum.com/showthread...hreadid=495477 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving Buttons
Steve
Try this link. Bob's is missing a couple or three characters. 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 others have posted that it didn't work for them in all their workbooks. Gord Dibben Excel MVP On Thu, 22 Dec 2005 10:31:08 -0600, stevepain wrote: Thanks for the input guys. Pedro - I tried your suggestion, and unfortunately it still appears to happen. Bob - unfortunately I cannot get your link to open - can you tell me how you reached that page,a dn perhaps I can navigate through the Microsoft support website myself? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I make 2003 use the buttons icons of 2000? | Excel Discussion (Misc queries) | |||
No Buttons to Control Subtotal Levels!?!? | Excel Discussion (Misc queries) | |||
Sort without moving buttons | Excel Discussion (Misc queries) | |||
Vanishing Control Toolbox Command Buttons | Excel Discussion (Misc queries) | |||
How do I stop VB buttons from moving in Excel after printing | Excel Discussion (Misc queries) |