Solved

Coomand button not visible

Posted on 2014-04-29
5
127 Views
Last Modified: 2014-04-30
Folks,
In my workbook on the first tab ("Menu") I have a command button called "GoToSelection". When I open the workbook I'd like to be able to change one of the properties Visible=False through VBA
0
Comment
Question by:Frank Freese
  • 3
  • 2
5 Comments
 
LVL 46

Accepted Solution

by:
Martin Liss earned 500 total points
ID: 40030691
In Workbook_Open put

GoToSelection. Visible = False  or

Sheets("Menu").GoToSelection. Visible = False
0
 

Author Comment

by:Frank Freese
ID: 40031963
Thanks - the first one did not work - variable not defined
The second one did
0
 

Author Closing Comment

by:Frank Freese
ID: 40031966
Thanks  - I appreciate it
0
 
LVL 46

Expert Comment

by:Martin Liss
ID: 40032409
You're welcome.
0
 

Author Comment

by:Frank Freese
ID: 40032578
Question on its way
0

Featured Post

ScreenConnect 6.0 Free Trial

Want empowering updates? You're in the right place! Discover new features in ScreenConnect 6.0, based on partner feedback, to keep you business operating smoothly and optimally (the way it should be). Explore all of the extras and enhancements for yourself!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question