Form Toolbar Customise Button

[Hibbster]

I have a macro assigned to a button from the form toolbar menu.

I only want the button to be visible depending on a selection of criteria.

I need to put some sort of conditional formatting on the button so that it only shows when it needs to based on the criteria being met.

Is this possible or am I going about it the wrong way?

Cheers

 

[Andrew Poulsom]

You can't conditionally format a button. What are the criteria?

 

[Hibbster]

Really simple.

If cell A1 = "Closed" then don't show the button, otherwise show the button.

 

[Andrew Poulsom]

What causes A1 to change?

 

[Hibbster]

The user enters a site code which runs a query and populates a sheet which info about the site. One piece of info being the closed status.

Is there anything else I can assign a macro to which will enable me to change the colour of the cell underneath. e.g. like a hyperlink

I'm using 2003 as well by the way.

 

[Andrew Poulsom]

You could use the Worksheet_Calculate (or maybe even the Worksheet_Change)event procedure to change the Visible property of the button.

 

[Hibbster]

I dont know much about event procedures but I will do some digging.

Thanks for your help.

 

[Hibbster]

I think I can go down the "follow hyperlink" route but my code activates for any hyperlink on the worksheet (I have several hyperlinks). Can I limit a "follow hyperlink" to a particular hyperlink?

 

[Andrew Poulsom]

The Hyperlink object has a Range property. You can use that to check the Address.