Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Creating macro button on toolbar


How would I go about creating a button on a toolbar to run a specifi
macro? I've done my research, and did the step by step of going t
Tool Customize added the custom button right clicking an
assigning the macro.

However, when I click on the button the macro doesn't run. Am I doin
something wrong?

Thanks for any help

--
tanyhar
-----------------------------------------------------------------------
tanyhart's Profile: http://www.excelforum.com/member.php...fo&userid=3514
View this thread: http://www.excelforum.com/showthread.php?threadid=56106

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Creating macro button on toolbar


The macro should work - assuming the macro is in the right spot. Whe
you press Alt+F8, you should see your macro. If you have it there
check to see if the macro is in design mode. Right click on a toolba
to pull up a list of the toolbars. Select Visual Basic toolbar. Go t
the design mode button and make sure it is not activated. If it is not
check to make sure the macros are enabled. If you have done all this an
it still doesn't work, then write back with the code to your macro - i
could be internal

--
kev_0
-----------------------------------------------------------------------
kev_06's Profile: http://www.excelforum.com/member.php...fo&userid=3504
View this thread: http://www.excelforum.com/showthread.php?threadid=56106

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Repetive Formatting/Creating a Toolbar button rllngriver Excel Discussion (Misc queries) 11 November 21st 07 01:38 PM
Creating a macro that simulates some of the toolbar button Duangruthai New Users to Excel 1 April 22nd 06 12:12 AM
Dynamically creating a toolbar button Gregory Kip[_2_] Excel Programming 1 March 14th 06 04:44 PM
Creating a Toolbar with a macro DavidP[_3_] Excel Programming 7 December 5th 03 10:22 AM
Creating a button on Excel Toolbar Todd Huttenstine[_2_] Excel Programming 2 December 1st 03 11:28 PM


All times are GMT +1. The time now is 02:05 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"