Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
cannot find code
I'm afraid I wasn't clear in my previous post. I don't know where to look in
the Excel file for the code that creates my new toolbar. My code was supposed to create the toolbar upon file/open then delete it when the file closed. I've searched every bit of code in the project, but the code does not appear. How can I access the code to create more buttons on the bar? "Ron de Bruin" wrote: Hi Gail Search Google for the subject http://groups.google.com/advanced_group_search Or use my add-in http://www.rondebruin.nl/Google.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Gail Hines" <Gail wrote in message ... 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) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
cannot find code
Hi
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. Maybe you copy it in your personal.xls Do you see this file when you do Alt-F11? -- Regards Ron de Bruin http://www.rondebruin.nl "hinesgg" wrote in message ... I'm afraid I wasn't clear in my previous post. I don't know where to look in the Excel file for the code that creates my new toolbar. My code was supposed to create the toolbar upon file/open then delete it when the file closed. I've searched every bit of code in the project, but the code does not appear. How can I access the code to create more buttons on the bar? "Ron de Bruin" wrote: Hi Gail Search Google for the subject http://groups.google.com/advanced_group_search Or use my add-in http://www.rondebruin.nl/Google.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Gail Hines" <Gail wrote in message ... 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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code to find code | Excel Discussion (Misc queries) | |||
Help with this Find code please | Excel Programming | |||
VBA code 'find next' | Excel Programming | |||
Find Code | Excel Programming | |||
VBA Code to FIND | Excel Programming |