Excel Question

Rrave26
Rrave26 used Ask the Experts™
on
I created a home worksheet tab with active x button controls that take a user to the corresponding worksheet tab.  However, when you click on the button and are taken to the screen and then migrate back to the home worksheet using the home button on the bottom the size of the orginal button on the home worksheet tab can change.  I say can because it is sporadic.  Do you have any idea of why that happens and how do I prevent the size of buttons from changing regardless of who opens the spreadsheet?
Prouduction-IM-METRICS-T-V01.xlsm
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Excel VBA Developer
Top Expert 2014
Commented:
Personally, I do not recommend using ActiveX controls for this very reason.  Instead, you should use regular form controls, which for the purposes of navigation through a workbook will work perfectly.

If you must keep these ActiveX controls, change the Format Control (right-click on each button in Design Mode), click the "Properties" tab and change the Object Positioning to "Don't move or size with cells".  This works MOST of the time, but not always.
ActiveX control - Format Control
-Glenn
Glenn RayExcel VBA Developer
Top Expert 2014

Commented:
PS  You could also set up Hyperlinked cells or drawing objects that would behave the same way, and with a little formatting, could look like buttons.
hyperlink examples

Author

Commented:
Thanks for the solution and the recomendation.  I will try out both.
Glenn RayExcel VBA Developer
Top Expert 2014

Commented:
You're welcome.  Personally, I prefer hyperlinks for navigation in Excel.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial