Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Ok, so I figured out how to create a macro that will creat a new toolba
for me, but when I run it, it creates the toolbar but none of th buttons are correct. The toolbar is supposed to hold buttons that ru other macros in the workbook. Am I doing something wrong? From looking in VBA, it is only recording the below, however I a entering more info during the recording of the macro. Any help will b greatly appreciated!! Sub TLD_Week_1() ' ' TLD_Week_1 Macro ' Macro recorded 6/13/2004 by Thomas ' ' Application.CommandBars.Add(Name:="TLD Week 1 Performance").Visibl = True Application.CommandBars("TLD Week 1 Performance").Controls.Ad Type:= _ msoControlButton, ID:=2950, Befo=1 Application.CommandBars("Stop Recording").Visible = False Application.CommandBars("TLD Week 1 Performance").Visible = False Application.WindowState = xlMinimized End Su -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
TOOLBAR FOR A MACRO | Excel Discussion (Misc queries) | |||
Macro button on toolbar | Charts and Charting in Excel | |||
macro in toolbar | Excel Discussion (Misc queries) | |||
macro toolbar | Excel Discussion (Misc queries) | |||
toolbar macro for esp. worksheet | Excel Programming |