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

Cosmos75 · Apr 8th, 2002, 01:24 PM

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 · Apr 8th, 2002, 01:27 PM

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 · Apr 8th, 2002, 01:33 PM

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

Cosmos75 · Apr 8th, 2002, 01:36 PM

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 · Apr 8th, 2002, 01:37 PM

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 · Apr 8th, 2002, 01:44 PM

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 · Apr 8th, 2002, 02:00 PM

Quote:

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

Apr 8th, 2002, 01:33 PM	#3
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Set the TakeFocus*******=false for that commandbutton. __________________ Kind regards, Al Chara

Apr 8th, 2002, 01:44 PM	#6
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	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. __________________ Kind regards, Al Chara

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 8th, 2002, 01:24 PM	#1
Cosmos75 Board Regular Join Date: Feb 2002 Location: Tulsa, OK Posts: 354	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 ]

Apr 8th, 2002, 01:27 PM	#2
Cosmos75 Board Regular Join Date: Feb 2002 Location: Tulsa, OK Posts: 354	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!!

Apr 8th, 2002, 01:36 PM	#4
Cosmos75 Board Regular Join Date: Feb 2002 Location: Tulsa, OK Posts: 354	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....

Apr 8th, 2002, 01:37 PM	#5
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	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 ]