After using Drawing Tools. now can't click macro buttons? HE

[Cosmos75]

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 ]

[Cosmos75]

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!!

[Al Chara]

Set the TakeFocus*******=false for that commandbutton.

[Cosmos75]

Al Chara,

TakeFocus*******=false

Do I have to specify which button it is? Or do I just insert TakeFocus*******=false? I am pretty new to VBA. Only so-so at using stuff like Range, Offset, Copy, Formula, Value, If Then statements....

[Mark O'Brien]

I don't think you can control that button in that way. I believe the control's state (i.e. on or off) is a read only property.

I've had that problem and I had to write that as a troubleshooting problem in the document I provided for my users.



_________________
[b] Mark O'Brien

[ This Message was edited by: Mark O'Brien on 2002-04-08 12:38 ]

[Al Chara]

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.

[Jay Petrulis]

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.

Hi,

You can set the .TakeFocus******* 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:

Range("A1").Select

and the control goes back to the worksheet.

Bye,
Jay