Excel Question

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
Rrave26Asked:
Who is Participating?
 
Glenn RayExcel VBA DeveloperCommented:
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
0
 
Glenn RayExcel VBA DeveloperCommented:
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
0
 
Rrave26Author Commented:
Thanks for the solution and the recomendation.  I will try out both.
0
 
Glenn RayExcel VBA DeveloperCommented:
You're welcome.  Personally, I prefer hyperlinks for navigation in Excel.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.