I recorded a macro to open the drawing toolbar to use the select function and select a couple of button used to run macros and now I can't click any other macro buttons!! HELP! This message was edited by Cosmos75 on 2002-04-08 12:28
I figured out that the select button on the drawing toolbar was still selected. Tried to record a macro to figure out how to de-lcik that button or turn it off. Excel didn't record and commands. HELP!!
Do I have to specify which button it is? Or do I just insert TakeFocusOnClick=false? I am pretty new to VBA. Only so-so at using stuff like Range, Offset, Copy, Formula, Value, If Then statements....
On 2002-04-08 12:44, Al Chara wrote:
You would have to set that property for the specific button, but I've never done it. And if mark thinks that it is read only, then it probably is.
You can set the .TakeFocusOnClick property. Check VBA help for specifics.
This property is for UserForms, I believe, or for items developed with the Control Toolbox, not with the Drawing/Forms objects.
However, I think the OP used the drawing toolbar to record the macro and stopped it too early. It may be that all that is needed is to return control to the worksheet. Add a line at the end like:
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.