Default a Command Button to invisible until it is made visible by another program

[GatesNJ]

Hi All - I'm relatively new to VBA, but seem to be a relatively quick study. I have a very complicated tool that I would like to add some dependent functionality to. I have a reporting tool that is linked to another "calculation" tool on a shared drive. I already have functionality that retrieves the calculation tool and saves it to an individual's computer with a specified file name. In the case where a user wants to make changes to the calculation settings/parameters of his/her personal file, I would like to make another macro that finds the saved file on the computer and works from that. Therefore, I would like my button to be invisible by default until certain conditions are met that are specified in the pre-requisite macro. I know to make it visible again is just 'CommandButton1.visible', but I don't know how to set it to an invisible default. Any help would be appreciated. Thanks

 

[bobsan42]

set it's VBE "Visible" property to False
Or
make it invisible during the starting/ loading/ opening event of the form or workbook that contains the button "CommandButton1.visible = False"