We help IT Professionals succeed at work.

Check out this week's podcast, "Dairy Farms to Databases: Community's Hand in Technology"Listen Now

x

Excel Question

216 Views
Last Modified: 2014-09-01
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

Excel VBA Developer
CERTIFIED EXPERT
Top Expert 2014
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Glenn RayExcel VBA Developer
CERTIFIED EXPERT
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
CERTIFIED EXPERT
Top Expert 2014

Commented:
You're welcome.  Personally, I prefer hyperlinks for navigation in Excel.
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.