• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 135
  • Last Modified:

Coomand button not visible

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
Frank Freese
Asked:
Frank Freese
  • 3
  • 2
1 Solution
 
Martin LissRetired ProgrammerCommented:
In Workbook_Open put

GoToSelection. Visible = False  or

Sheets("Menu").GoToSelection. Visible = False
0
 
Frank FreeseAuthor Commented:
Thanks - the first one did not work - variable not defined
The second one did
0
 
Frank FreeseAuthor Commented:
Thanks  - I appreciate it
0
 
Martin LissRetired ProgrammerCommented:
You're welcome.
0
 
Frank FreeseAuthor Commented:
Question on its way
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now