Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
A way to create a Command Bar without code???
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
A way to create a Command Bar without code???
Yes.
1 - View/Toolbars/Customize 2 - Click New 3 - Enter a name for the toolbar, Click OK 4 - Click the Commands Tab 5 - Select the tool bar buttons you want to put on the command bar 6 - repeat 5 until it's what you want 7 - Done. "JB" 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
A way to create a Command Bar without code???
ok... commandbar, toolbar are one and the same... got it.
That still leaves me without a solution to my original post... (SEE BELOW) ... I copied all of my macros into a blank spreadsheet... via VB editor... moved modules containing macros from old spreadsheet into a new. .... while still in the new book, I created the toolbar, inserted the macro buttons with links to the macros recently moved to this new book. I saved the file "my-macros.xls" and then saved as an add- in "my-macros.xla", opened the spreadsheet I am working on and loaded the add-in. Everything works until I remove/delete "my-macros.xls". then the macros are looking to the old .xls file, not to the .xla add-in which I loaded. THE ADD-IN FILE IS NOT SELF CONTAINED!! I NEED TO BE ABLE TO DISTRIBUTE THE FILE TO ALL IN MY DEPARTMENT WITHOUT HAVING TO SET UP NEW TOOLBARS/BUTTONS/MACROS ON EVERY MACHINE FOR EVERY USER. Thoughts?? Thanks for your help! JB -----Original Message----- Yes. 1 - View/Toolbars/Customize 2 - Click New 3 - Enter a name for the toolbar, Click OK 4 - Click the Commands Tab 5 - Select the tool bar buttons you want to put on the command bar 6 - repeat 5 until it's what you want 7 - Done. "JB" 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? . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
A way to create a Command Bar without code???
JB,
Try running the macro below to change the link from the .xls to the .xla file. You can also change the path by modifying the code, but as written this assumes both files are in the same folder. HTH, Bernie MS Excel MVP Sub RepairUserDefinedButtons3() Dim CmdBar As CommandBar Dim i As Integer On Error GoTo ErrorReading: For Each CmdBar In CommandBars For i = 1 To CmdBar.Controls.Count If CmdBar.Controls(i).BuiltIn = False Then If InStr(1, CmdBar.Controls(i).OnAction, _ "my-macros.xls") Then CmdBar.Controls(i).OnAction = _ Replace(CmdBar.Controls(i).OnAction, _ "my-macros.xls", "my-macros.xla") End If End If ErrorReading: Next i Next CmdBar End Sub "JB" wrote in message ... ok... commandbar, toolbar are one and the same... got it. That still leaves me without a solution to my original post... (SEE BELOW) ... I copied all of my macros into a blank spreadsheet... via VB editor... moved modules containing macros from old spreadsheet into a new. ... while still in the new book, I created the toolbar, inserted the macro buttons with links to the macros recently moved to this new book. I saved the file "my-macros.xls" and then saved as an add- in "my-macros.xla", opened the spreadsheet I am working on and loaded the add-in. Everything works until I remove/delete "my-macros.xls". then the macros are looking to the old .xls file, not to the .xla add-in which I loaded. THE ADD-IN FILE IS NOT SELF CONTAINED!! I NEED TO BE ABLE TO DISTRIBUTE THE FILE TO ALL IN MY DEPARTMENT WITHOUT HAVING TO SET UP NEW TOOLBARS/BUTTONS/MACROS ON EVERY MACHINE FOR EVERY USER. Thoughts?? Thanks for your help! JB -----Original Message----- Yes. 1 - View/Toolbars/Customize 2 - Click New 3 - Enter a name for the toolbar, Click OK 4 - Click the Commands Tab 5 - Select the tool bar buttons you want to put on the command bar 6 - repeat 5 until it's what you want 7 - Done. "JB" 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? . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
A way to create a Command Bar without code???
Just change the onaction property of the buttons to point to the xla
instead. Yelling at us won't help. We aren't having the problem or causing it. -- Regards, Tom Ogilvy "JB" wrote in message ... ok... commandbar, toolbar are one and the same... got it. That still leaves me without a solution to my original post... (SEE BELOW) ... I copied all of my macros into a blank spreadsheet... via VB editor... moved modules containing macros from old spreadsheet into a new. ... while still in the new book, I created the toolbar, inserted the macro buttons with links to the macros recently moved to this new book. I saved the file "my-macros.xls" and then saved as an add- in "my-macros.xla", opened the spreadsheet I am working on and loaded the add-in. Everything works until I remove/delete "my-macros.xls". then the macros are looking to the old .xls file, not to the .xla add-in which I loaded. THE ADD-IN FILE IS NOT SELF CONTAINED!! I NEED TO BE ABLE TO DISTRIBUTE THE FILE TO ALL IN MY DEPARTMENT WITHOUT HAVING TO SET UP NEW TOOLBARS/BUTTONS/MACROS ON EVERY MACHINE FOR EVERY USER. Thoughts?? Thanks for your help! JB -----Original Message----- Yes. 1 - View/Toolbars/Customize 2 - Click New 3 - Enter a name for the toolbar, Click OK 4 - Click the Commands Tab 5 - Select the tool bar buttons you want to put on the command bar 6 - repeat 5 until it's what you want 7 - Done. "JB" 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 | |||
Command code | Excel Discussion (Misc queries) | |||
command code ( GOTO command) in formula | New Users to Excel | |||
How to create a form to insert a hyerlink.VBA code to create a for | Excel Discussion (Misc queries) | |||
VBA code for Autosum command | Excel Programming | |||
Create Command Button from Code | Excel Programming |