Bill Golden
asked on
Macro buttons ending up in different location each time certain functions of Format Control are used.
Everytime I go to tweak the size of a macro button with Format Control, the macro ends up 5 or 6 cells above its current position. Offending worksheet is attached. Try and adjust the ViewChart2 macro button. (The height should be 0.20" instead of 0.19") You can adjust it, but the macro will end up in another location. Try it!
Billing-Calc-5-Sample-version-8N-EE.xls
Billing-Calc-5-Sample-version-8N-EE.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Sorry cannot replicate
ASKER
Try the ViewChart2 macro button. Change the height to 0.22"
ASKER
Sort of solved the problem.
Evidently it is an anomaly when using Excel 2013 on an older Excel worksheet. Problem does not happen when using Excel 2003. Your inability to duplicate the problem got me to thinking about possible differences between the two programs.
Thanks.
Bill
Evidently it is an anomaly when using Excel 2013 on an older Excel worksheet. Problem does not happen when using Excel 2003. Your inability to duplicate the problem got me to thinking about possible differences between the two programs.
Thanks.
Bill
ASKER