View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gail Hines Gail Hines is offline
external usenet poster
 
Posts: 1
Default cannot find code

Using messages previously posted on this site I used code to create a custom
toolbar when file is opened. I now need to edit the toolbar, but I can't
locate the original code.

Here is partial content of previous message (which I also cannot locate).

From: Dave Peterson )
Subject: Separate Code and Data (Newbie Q)
View this article onlyNewsgroups: microsoft.public.excel
Date: 2004-06-28 15:05:08 PST
The code can be in any workbook. But if you have to click on a button (on
aworksheet?), then you're going to have a little trouble--since the
worksheetwith the button will be the activesheet.One way around it is to use
Tools|macro|macros..., to run the macro.Another way is to save your workbook
with the code as an addin. (In thefile|saveAs|Save as type dropdown box.)But
if your workbook is an addin, you'll need a different method to invoke
themacro.I really like John Walkenbach's MenuMaker for creating a nice access
to mymacros.http://j-walk.com/ss/excel/tips/tip53.htmAnother way is to add
another toolbar. I'd create the toolbar when the workbookwith the code opens
and delete the toolbar when you close that workbook.Here's a shell that I
keep when I want to add a custom toolbar:In a general module:Option
ExplicitSub create_menubar() Dim i As Long Dim mac_names As Variant
Dim cap_names As Variant Dim tip_text As Variant Call
remove_menubar mac_names = Array("mac1", _
"mac2", _ "mac3") cap_names =
Array("caption 1", _ "caption 2", _
"caption 3") tip_text = Array("tip 1", _
"tip 2", _ "tip 3") With
Application.CommandBars.Add .Name = "MyToolbar"
Read the rest of this message... (61 more lines)