Opv
04-24-2010, 10:08 AM
I am experimenting with some buttons in my worksheets to call and activate various macros. I am wondering if there is a way similar to what can be done using Javascript to have one button which serves two purposes. By that I mean, if I currently have two buttons, one that has a text label, "Filter Data" and another which has a text label, "Show Data." These buttons call the "filterData" and "unfilterData" macros respectively.
Is there a way to use just one button? I mean, is there a way to cause the text lable to change from "Filter Data" to "Show Data" once the button is clicked and the filter macro has been activated, then if I click on the button again it would call the showData macro?
Is there a way to use just one button? I mean, is there a way to cause the text lable to change from "Filter Data" to "Show Data" once the button is clicked and the filter macro has been activated, then if I click on the button again it would call the showData macro?