Commandbuttons

G

Guest

I would like to be able to click commandbutton1 on sheet A, so
commandbutton2 on sheet B becomes visible. If Commandbutton 1 isn't clicked
on sheet A then Commandbutton2 on Sheet B is left invisible.
 
C

Corey

Steve,
Try,

Sheet2.CommandButton2.Visible = True '<=== Modify sheet2 to suit what sheet
the commanbutton is on

In code for commandbutton2 place:
Commandbutton2.visible = false

Corey....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Command Button Dependent on Cell/Range Value 1
how to get commandbutton name 2
question regarding Visible Propery 2
How to enumerate buttons on user form 2
Username and password login. 10
Code cleanup help 4
How to execute a CommandButton_Click macro without clicking on 4
Userforms and public variables 2

Top