If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
attaching toolbar to add-inn without using code?
Is there anyway of attaching a toolbar to an .xla without
using code? I am not a programmer. Subject: Can I attach a toolbar to an add-in? From: "Tom Ogilvy" Sent: 8/17/2004 8:18:24 AM instead of attaching your toolbar, create it with code in your xla. At that time you can assign your macros and they will point to the xla. Here is an article about creating commandbars with code: http://msdn.microsoft.com/library/techart/ofcmdbar.htm I guess as an alternative, you could attach your toolbar and then have you code go through and assign the correct macro to the onaction property of each control. This would be done in the open event of the XLA so it occurs when the XLA is loaded. -- Regards, Tom Ogilvy "JB" wrote in message ... I need to deploy my .xla file to all in my department. I have created macros and a toolbar with buttons pointing to the macros... and saved as "my macros.xls". When I save the file as "my macros.xla", the toolbar which was attached remains attached to the "my macros.xls"... thus the .xla IS NOT SELF-CONTAINED. It does not appear that I can open the .xla file in order to attach the toolbar. Thoughts? Thanks for your help! JB |
#2
|
|||
|
|||
If you turn your addin back into a .xls, you can attach a toolbar to the
workbook. Then save it as an addin. But if you're going to do this, read these notes by Jan Karel Pieterse: http://google.com/groups?threadm=083...0a% 40phx.gbl JB wrote: Is there anyway of attaching a toolbar to an .xla without using code? I am not a programmer. Subject: Can I attach a toolbar to an add-in? From: "Tom Ogilvy" Sent: 8/17/2004 8:18:24 AM instead of attaching your toolbar, create it with code in your xla. At that time you can assign your macros and they will point to the xla. Here is an article about creating commandbars with code: http://msdn.microsoft.com/library/techart/ofcmdbar.htm I guess as an alternative, you could attach your toolbar and then have you code go through and assign the correct macro to the onaction property of each control. This would be done in the open event of the XLA so it occurs when the XLA is loaded. -- Regards, Tom Ogilvy "JB" wrote in message ... I need to deploy my .xla file to all in my department. I have created macros and a toolbar with buttons pointing to the macros... and saved as "my macros.xls". When I save the file as "my macros.xla", the toolbar which was attached remains attached to the "my macros.xls"... thus the .xla IS NOT SELF-CONTAINED. It does not appear that I can open the .xla file in order to attach the toolbar. Thoughts? Thanks for your help! JB -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
VBA Code Help - Badly needed | venus as a boy | General Discussion | 1 | July 20th, 2004 06:53 PM |
Map code to label in query | Attila Fust | Running & Setting Up Queries | 4 | July 16th, 2004 04:36 PM |
Hi! Urgent pls: Protecting sheets so macros/buttons still work? | StargateFanFromWork | General Discussion | 7 | July 3rd, 2004 02:25 PM |
Strange annoying problem - long chunk of code | John | General Discussion | 2 | June 10th, 2004 07:27 AM |
Strange annoying problem - long chunk of code | John | Using Forms | 1 | June 10th, 2004 03:37 AM |