Hide/Unhide Command Button

[xc405]

I have a command button "Calculate", i want it to be hidden until the user clicks a button called "New Facility" on a different sheet. I'm not sure how to upload my workbook so I'll give you a quick explanation of how i would like it be hidden.

Sheet 1-GeneralInfo: Fills out info
Sheet 2-SiteInformation: Fills out info----Command Button Calculate is hidden.
Sheet 3 to 4-Checklist, Stacks: Fills out info
Sheet 5-Flowchart: Clicks the "New Facility" button and it takes you back to Sheet 2 and unhides the "Calculate" command button.

Here is my code for the "Calculate" button:

Sub Calculate_Click()
    Dim ws As Worksheet
    Set ws = Worksheets("LossesSummary")
    ws.Activate
    MsgBox "This Sheet does not calculate Flare Loss." & vbCrLf & "By clicking the Flare checkbox you only show that you plan on installing a Flare.", vbOKOnly, "devon Energy"
End Sub

Any help would be appreciated !

 

[HalfAce]

Where did these buttons come from? - The Forms, or the Controls Toolbox toolbar?

If you use a button from Controls Toolbox (these are ActiveX controls) then you can go into the properties for your 'Calculate' button and name it. (I named it 'CalcButton'.) Then, down at the bottom of the button's properties, set the Visible property to False.

In the code of your New Facility button, you can include something like:

With Sheets("SiteInformation")
  .Activate
  .CalcButton.Visible = True
End With

You'll have to figure out what criteria you want met before resetting the button's visible property back to False, but you can do that the same way too.

Does that help?

 

[xc405]

They aren't activeX controls because I use a Mac but they are forms from the toolbox. If they were activeX it would be easy but I'm not sure how to get it to work.