Excel After using Drawing Tools. now can't click macro buttons? HE :: MrExcel Message Board
Excel Keyboard


 FAQFAQ
   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   FavoritesFavorites   StatisticsStatistics 
 RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
Online StoreOnline Store

MrExcel Message Board Forum Index -> Excel Questions

After using Drawing Tools. now can't click macro buttons? HE
Post new topic   Reply to topic
Last Thread | Next Thread  >   Printable version
  Author    Thread

Cosmos75
Board Master


Joined: 01 Mar 2002
Posts: 297
Location: Tulsa, OK

Status: Offline

 Reply with quote  

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 ]

Post Mon Apr 08, 2002 4:24 pm 
 View user's profile Send private message

Cosmos75
Board Master


Joined: 01 Mar 2002
Posts: 297
Location: Tulsa, OK

Status: Offline

 Reply with quote  

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

Post Mon Apr 08, 2002 4:27 pm 
 View user's profile Send private message

Al Chara
MrExcel MVP


Joined: 22 Feb 2002
Posts: 1428
Location: Monterrey, Mexico
Flag: Usa

Status: Offline

 Reply with quote  

Set the TakeFocusOnClick=false for that commandbutton.

_________________
Kind regards,

Al Chara

Post Mon Apr 08, 2002 4:33 pm 
 View user's profile Send private message

Cosmos75
Board Master


Joined: 01 Mar 2002
Posts: 297
Location: Tulsa, OK

Status: Offline

 Reply with quote  

Al Chara,

TakeFocusOnClick=false

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

Post Mon Apr 08, 2002 4:36 pm 
 View user's profile Send private message

Mark O'Brien
MrExcel MVP


Joined: 16 Feb 2002
Posts: 3155
Location: Columbus, OH, USA
Flag: Scotland

Status: Offline

 Reply with quote  

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.



_________________
Mark O'Brien

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

Post Mon Apr 08, 2002 4:37 pm 
 View user's profile Send private message

Al Chara
MrExcel MVP


Joined: 22 Feb 2002
Posts: 1428
Location: Monterrey, Mexico
Flag: Usa

Status: Offline

 Reply with quote  

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

Post Mon Apr 08, 2002 4:44 pm 
 View user's profile Send private message

Jay Petrulis
MrExcel MVP


Joined: 18 Mar 2002
Posts: 1674
Location: Chicago, IL USA
Flag: Blank

Status: Offline

 Reply with quote  


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 .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:

Range("A1").Select

and the control goes back to the worksheet.

Bye,
Jay

Post Mon Apr 08, 2002 5:00 pm 
 View user's profile Send private message
  Display posts from previous:      

MrExcel Message Board Forum Index -> Excel Questions


Forum Jump:
Jump to:  

Post new topic   Reply to topic
Page 1 of 1



Add To Favorites

 


Forum Rules:
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Powered by phpBB: 2.0.4 © 2001 phpBB Group

Need help posting your first question? Read how to post

Need extra help ? Couldn't get the answer you needed ? Get a free quote from our Consulting Team

Download Colo's HTML Maker utility for displaying your Excel Worksheet on the board.

Download VB HTML Maker to post your code on the board


Check out our new index to 485 Excel Articles.


Return to MrExcel Consulting

All contents Copyright 1998-2004 by MrExcel.com
If you believe information posted here is from your copyrighted source, notify us per the Terms of Use
Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.