Link to home
Start Free TrialLog in
Avatar of Bill Golden
Bill GoldenFlag for United States of America

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
ASKER CERTIFIED SOLUTION
Avatar of Rgonzo1971
Rgonzo1971

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Bill Golden

ASKER

Same outcome. But cells are ending up below their original position now instead of above the original position - if that helps.
Avatar of Rgonzo1971
Rgonzo1971

Sorry cannot replicate
Try the ViewChart2 macro button. Change the height to 0.22"
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