Solved

Coomand button not visible

Posted on 2014-04-29
5
125 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 45

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 45

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

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
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 …
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

707 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now