Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Attaching toolbars to spreadsheet, but macros do not follow?
I have created some macros which everyone in my department
uses. I am trying to find the best way for everyone to have access to these macros AND THE TOOLBAR which has buttons linked to the macros. I see one of two ways of doing this. 1) I can place my "office macros.xls" file in everyone's XLSTART folder, but then I have to create the toolbar and buttons for every user on every computer (we do a lot of PC swapping). 2)We have an Excel template which we use at the beginning of each project... I can embed the macros into the template and attach the toolbar to the template. Here is my problem. The first way is very time consuming, and anytime I create a new macro or have a change it will be a big headache to make the change for everyone. The second way does not work... I can embed the macros and attach the toolbars, but when I set up the macro buttons in the toolbar and then Copy the template to another PC/folder, the macros don't follow... they point back to the original template which has the macros... not to the current file with the macros embedded. Any ideas? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Attaching toolbars to spreadsheet, but macros do not follow?
One way is to create an addin and put it on a common drive. Then have each
user reference the addin through tools=Addins so it is opened each time excel it opened. this allows you to update the file if necessary and everyone will get the newest version. Create the commandbars with code in the addin (and delete the existing verion) each time it is opened. Doing anything on each computer is a non-starter in my opinion. http://msdn.microsoft.com/library/ba...n_addins97.htm http://msdn.microsoft.com/library/of...exceladdin.htm http://www.microsoft.com/exceldev/tips/addins.htm These are about distributing applications Here is an article about creating commandbars with code: http://msdn.microsoft.com/library/techart/ofcmdbar.htm http://support.microsoft.com/default...02&Product=xlw How to customize menus and menu bars in Excel -- Regards, Tom Ogilvy "JB" wrote in message ... I have created some macros which everyone in my department uses. I am trying to find the best way for everyone to have access to these macros AND THE TOOLBAR which has buttons linked to the macros. I see one of two ways of doing this. 1) I can place my "office macros.xls" file in everyone's XLSTART folder, but then I have to create the toolbar and buttons for every user on every computer (we do a lot of PC swapping). 2)We have an Excel template which we use at the beginning of each project... I can embed the macros into the template and attach the toolbar to the template. Here is my problem. The first way is very time consuming, and anytime I create a new macro or have a change it will be a big headache to make the change for everyone. The second way does not work... I can embed the macros and attach the toolbars, but when I set up the macro buttons in the toolbar and then Copy the template to another PC/folder, the macros don't follow... they point back to the original template which has the macros... not to the current file with the macros embedded. Any ideas? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Attaching toolbars to spreadsheet, but macros do not follow?
Is there a way to create a Command Bar without code???
I AM NOT A PROGRAMMER... I know excel and can make my way arround VB for applications... though I could probobly do it, I do not have the time it would take for me to try and figure this out in code. -----Original Message----- One way is to create an addin and put it on a common drive. Then have each user reference the addin through tools=Addins so it is opened each time excel it opened. this allows you to update the file if necessary and everyone will get the newest version. Create the commandbars with code in the addin (and delete the existing verion) each time it is opened. Doing anything on each computer is a non-starter in my opinion. http://msdn.microsoft.com/library/ba...tml/msdn_addin s97.htm http://msdn.microsoft.com/library/of...odeopg/deovrcr eatingexceladdin.htm http://www.microsoft.com/exceldev/tips/addins.htm These are about distributing applications Here is an article about creating commandbars with code: http://msdn.microsoft.com/library/techart/ofcmdbar.htm http://support.microsoft.com/default.aspx?scid=kb;en- us;830502&Product=xlw How to customize menus and menu bars in Excel -- Regards, Tom Ogilvy "JB" wrote in message ... I have created some macros which everyone in my department uses. I am trying to find the best way for everyone to have access to these macros AND THE TOOLBAR which has buttons linked to the macros. I see one of two ways of doing this. 1) I can place my "office macros.xls" file in everyone's XLSTART folder, but then I have to create the toolbar and buttons for every user on every computer (we do a lot of PC swapping). 2)We have an Excel template which we use at the beginning of each project... I can embed the macros into the template and attach the toolbar to the template. Here is my problem. The first way is very time consuming, and anytime I create a new macro or have a change it will be a big headache to make the change for everyone. The second way does not work... I can embed the macros and attach the toolbars, but when I set up the macro buttons in the toolbar and then Copy the template to another PC/folder, the macros don't follow... they point back to the original template which has the macros... not to the current file with the macros embedded. Any ideas? . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Attaching toolbars to spreadsheet, but macros do not follow?
Here is an article about attaching toolbars:
http://www.microsoft.com/exceldev/articles/toolbatt.htm http://support.microsoft.com/default...&Product=xlw2K XL2000: How to Customize a Custom Toolbar Button http://support.microsoft.com/default...&Product=xlw2K OFF2000: How to Add a Command to a New Toolbar -- Regards, Tom Ogilvy wrote in message ... Is there a way to create a Command Bar without code??? I AM NOT A PROGRAMMER... I know excel and can make my way arround VB for applications... though I could probobly do it, I do not have the time it would take for me to try and figure this out in code. -----Original Message----- One way is to create an addin and put it on a common drive. Then have each user reference the addin through tools=Addins so it is opened each time excel it opened. this allows you to update the file if necessary and everyone will get the newest version. Create the commandbars with code in the addin (and delete the existing verion) each time it is opened. Doing anything on each computer is a non-starter in my opinion. http://msdn.microsoft.com/library/ba...tml/msdn_addin s97.htm http://msdn.microsoft.com/library/of...odeopg/deovrcr eatingexceladdin.htm http://www.microsoft.com/exceldev/tips/addins.htm These are about distributing applications Here is an article about creating commandbars with code: http://msdn.microsoft.com/library/techart/ofcmdbar.htm http://support.microsoft.com/default.aspx?scid=kb;en- us;830502&Product=xlw How to customize menus and menu bars in Excel -- Regards, Tom Ogilvy "JB" wrote in message ... I have created some macros which everyone in my department uses. I am trying to find the best way for everyone to have access to these macros AND THE TOOLBAR which has buttons linked to the macros. I see one of two ways of doing this. 1) I can place my "office macros.xls" file in everyone's XLSTART folder, but then I have to create the toolbar and buttons for every user on every computer (we do a lot of PC swapping). 2)We have an Excel template which we use at the beginning of each project... I can embed the macros into the template and attach the toolbar to the template. Here is my problem. The first way is very time consuming, and anytime I create a new macro or have a change it will be a big headache to make the change for everyone. The second way does not work... I can embed the macros and attach the toolbars, but when I set up the macro buttons in the toolbar and then Copy the template to another PC/folder, the macros don't follow... they point back to the original template which has the macros... not to the current file with the macros embedded. Any ideas? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
attaching Excel spreadsheet | Excel Discussion (Misc queries) | |||
attaching an image to Excel spreadsheet cell | Excel Worksheet Functions | |||
Macros in a template run from Custom Toolbar attaching to wrong file. | Excel Programming | |||
Problems Attaching Macros to Command Button | Excel Programming | |||
Attaching Macros to Custom Buttons | Excel Programming |