Saving custom toolbars with macros to work on other computers

I have created a series of Macros in excel, and have alocated them to a 
custom toolbar I have made.  Is there a way which I can save the toolbar and 
macros with the excel spreadsheet, so tht the whole set-up can be used on a 
seperate computer?
jpw48 (1)
9/1/2005 10:42:01 AM
excel.misc 78881 articles. 5 followers. Follow

2 Replies

Similar Articles

[PageSpeed] 8

Macros are always saved with the workbook that they are in.  To attach a 
toolbar to that workbook you use View, Toolbars, Customize and click the 
Attach button on the Toolbars tab.  Then Save the workbook.

That's the easy way but it has some drawbacks.  If you make a change to the 
toolbar (like adding a new button) you must remember to re-attach the 
toolbar to the workbook.  Making such a change and saving the workbook is 
not enough, you must Attach again (when you change the toolbar, not the 
code).  Also, if you send someone the workbook he will see your toolbar when 
he opens the workbook.  But then that toolbar will become part of his 
toolbar set, with or without your workbook.  If he deleted your workbook the 
toolbar would still be there and he'd get an error if he used it.  Another 
problem is that if you modify the toolbar, reattached it to the workbook and 
send the workbook to a current user, when he opens it he will still see the 
old toolbar. This is because he already has a toolbar with the same name 
(your old one) and the old one blocks the new one.  Before he opens your 
workbook he has to delete the old toolbar manually.  To make that 
unnecessary you should add an auto_close macro to your workbook that deletes 
the toolbar, so that the toolbar is never saved with the user's toolbar set.

To avoid all these issues the pros do not attach toolbars to workbooks. 
Instead they build the toolbar with VBA code that's executed when the 
workbook opens.  That's a subject that goes beyond the scope of this 

"jpw48" <> wrote in message
| Hi
| I have created a series of Macros in excel, and have alocated them to a
| custom toolbar I have made.  Is there a way which I can save the toolbar 
| macros with the excel spreadsheet, so tht the whole set-up can be used on 
| seperate computer? 

jrrech (1933)
9/1/2005 12:06:51 PM
Just to add to Jim's reply.

Here's how I create that toolbar on the fly:

If you want to add items to the worksheet menu bar, you can use John
Walkenbach's menumaker:

jpw48 wrote:
> Hi
> I have created a series of Macros in excel, and have alocated them to a
> custom toolbar I have made.  Is there a way which I can save the toolbar and
> macros with the excel spreadsheet, so tht the whole set-up can be used on a
> seperate computer?


Dave Peterson
petersod (12004)
9/1/2005 12:43:08 PM

Similar Artilces:

Adding additional users to a client computer
I'm running SBS 2003 R2. I have a number of client computers connected to the server, but each of these has been allocated only one user account. Local reorganisation has led the users to ask if they can be allowed to log into any computer, not just the one they used to. SBS provides a setup computer wizard where you can add a new computer and then add users to it. However this won't work with an existing computer, and I can't find an obvious way of doing this from the server. (I had looked at establishing roaming profiles as a possible way around this, but th...

vlookup issue ( not working and im tearing my hair out)
Okay , well i cant discuss the actual info in my sheet but ill come up with a good analogy of it all . Ok basically on sheet 2 i have all the teams in my NHL ( my company) listed under the immediate manager. I also have the players last name, first name and number set out as such ; Team A Shivers Paul 14 Jacobsen John 25 Tucker Tanya 98 Team B Pitt Brad 22 Murray Bill 28 Clinton Hillary 55 You get the point, ok , on sheet 1 ( my main page accessible to my company ) , i have this format... Managers last name Players last name ...

FileNotFound returned by Bitmap::Save() when saving to stream
I have a little chunk of code which is supposed to take a bitmap image and save its PNG encoding into a block of memory. The problem is, I keep getting a FileNotFound error back from Save(). If anyone has any ideas, I'd love to hear them. Here's the code (more or less) in question; there really shouldn't be much to it, I would have thought: /* Allocate an IStream object to write the data into a global memory block. We indicate that the handle to the underlying data will be freed when the stream object is released. */ VERIFY(S_OK == ::CreateStreamOnHGlobal(nil, True, static_c...

Outlook wont work!
I just bought a new computer that came with a trial version of MS Office 2003. Since I already have MS Office Pro XP, I uninstalled the trial versions and installed my CD. Everything works (Word, Excel, Powerpoint, Frontpage, etc..) except Outlook. When I start the program up it says "cannot load default email folders, would you like to open the default system folder instead?" (something to that effect). Outlook then opens My Computer. There's no calendar available, no email....basically it becomes a fancy windows explorer. I've tried uninstalling and reinstalling my co...

Handling of savings accounts and 401k accounts in the budget
I noticed that Money treats money that I contribute to a 401k account or transfer to a savings account as an expense. Basically, the more I contribute, the worse my budget looks. Is there a way to prevent this from happening? Right now, I exclude transfers to my savings account from the budget and it solves the problem, however, I shouldn't have to manually do this each time. For 401k contributions, I cannot find a way to do this. Why does it show up as "an expense" (what Category???) instead of something like Transfer Out of Budget Accounts? The 401k cash account sh...

printing customer statements.
Two of my RMS customers are very unhappy about the lack of options in printing customer statements. I have not been able to find a solution for either customer. Dixie Products, Inc. needs to print selected groups of customer statements. They have different types of customers and have requested the ability to select out which customer statements to print. Dixie upgraded to RMS from Quick Sell 2000. They say QS2000 had the ability to run selected statements and they would not have purchased RMS if they had known of this limitation. Another Customer needs to exclude printing statements w...

Unable to save password in Outlook 2003
I cannot seem to save my "network password" for Outlook 2003. I tried everything I can think of. I tried editing the registry. I use XP. I try going into Control Panel, go to mail and go thru the process there and....nothing worked there. I uninstalled Office the reinstalled it.....nothing! I even went as far as unistalling my internet software, still...nothing! Someone told me that XP will not save passwords. My Outlook express works fine. Someone HELP! I also had this issue in Outlook 2003, but also in indows Live Messenger and Internet Explorer 7. I spend hour...

what encoding does path) use to save the xml document if there is no <?xml... in the front of the xml document?
what encoding does path) use to save the xml document if there is no <?xml... in the front of the xml document? Daniel wrote: > what encoding does path) use to save the > xml document if there is no <?xml... in the front of the xml document? UTF-8 is the default encoding. -- Oleg Tkachenko [XML MVP, MCPD] | http://www.XmlLab.Net | http://www.XLinq.Net utf8 i suppose would be default Vinu Baby "Daniel" <> wrote in message news:e8#...

Workbook Specific Toolbar Menus
I was proud of myself in creating a new toolbar menu and sub-menu and assigning macros to the menu items until I discovered that the menu appears on the toolbar always now, regardless of the spreadsheet I open. It appears that when I select a custom menu item, it's going out the the spreadsheet where it is stored and executing it against the spreadsheet I have open (great, but that's not what I want). How do I create toolbar menus that only appear for a specific spreadsheet when it is open? -- Steve Steve, The best option is to create the commandbar on the fly, when the work...

Save and save as
Hi, I am looking for some help with a macro, I need to disable anyone from saving a file or save as and also disable the prompt if the close button is pressed you get an option to save the file then, I need to disable all of these, also have a pop up box to warn that save as been disables when a user tries to save the file fro save and save as. Can anyone help me with this. I am using word 2003 Regards Mark Once you give someone access to a document, you have ceded all control over it. You can however stop them from overwriting the original file by making the doc...

Outlook- Customize Outlook today
Hello, After I downloaded windows update I'm no longer able to use the Customize Outlook today button. I get no errors. I get nothing at all. Any idea's how to fix this? Jeff This may help;EN-US;820575 "Jeff" <> wrote in message news:08d501c3b28e$fd373620$a101280a@phx.gbl... > Hello, > > After I downloaded windows update I'm no longer able to > use the Customize Outlook today button. I get no errors. I > get nothing at all. Any idea's how to fix this? > &...

Saving Images
When I right click to save an image in an email, it will only save as a .bmp. I need to use it as a .jpeg or a .gif. How can I fix this? In, Angi <> typed: > When I right click to save an image in an email, it will only save as > a .bmp. I need to use it as a .jpeg or a .gif. How can I fix this? Clear your internet explorer temp file cache.....go to control panel, internet options, and choose 'delete files' "Angi" <> wrote in message...

Why would a Windows Scheduled Task stop working?
Hello: Several weeks ago, I developed a .cmd file that runs a GP macro (.mac file). It runs perfectly. Then, I created a task through Windows Server 2003 Task Scheduler that runs this .cmd. and therefore the macro, automatically. The task works perfectly, when I right-click on the task and choose "Run". And, for three weeks, Task Scheduler ran this .cmd file automatically. Then, a few days ago, it stopped running the .cmd file at its scheduled time. Again, if I right-click on it and choose "Run", it does run. But, why would the Windows Task Scheduler all of a s...

"Unattainable" savings goals
I've learned to mostly ignore it, but it drives me batty. I have a particular loan with a goal to pay it off by 7/4/04. The loan balance is 14,000. I have marked a savings account to be "used for budgeted savings goals." I deposit $1300 per month into the account which has a balance currently of $13000. Money 2K4 says that I cannot reach my savings goal. What can I do to help fix this? Any feedback would be appreciated! ...

Saving default tabs
I can't seem to get a change in the default tab setting to save. When I reopen publisher the tab setting reverts to .5 which was original default. I'm I the only person who is having this problem? I'm using the 2003 verson but had the same problem with 2000. Why not take the default page, set the tabs you want and save it as a template with a file name of, "My Very Special Tabs Settings for Future" (jerking your chain a bit<G>) Then when you want to create what you want, use your created template file and when your pub file is what you want, do a Sa...

Save to unProtect a Document?
Our company has word documents that we use as templates on a fileserver. How could I protect the documents so that when they open them, they dont make changes to the server version, but save their OWN version and do what they want? First of all, make use of true *template* files (with the *.dot or *.dotx extension). Also, assign the template files the read-ony attribute. -- Stefan Blom Microsoft Word MVP "Chris" <> wrote in message > Our company has word docum...

Save csv format to dbf format
I have a .csv file with 13 columns of data opened in excel. I make a few changes to a field and then want to save to .dbf format. After saving as .dbf when I open the file only column 1 data is present. Any insights into where the rest of the data goes? Why does the data disappear? Thanks, Mike -- mdelasaux ------------------------------------------------------------------------ mdelasaux's Profile: View this thread: Try using Notepad and open your .dbf...

Macro for Sub totaling multiple sheets
I'm having a problem with a sub total macro. I'm in charge of credit and risk management for a company, and we have about 40 sales agents. Our trial balance needs to be dumped from our system into excel, then broken by sales agent. The problem is each sales agent's aging is not equal, as far as the rows go, I cant seem to get a Marco to work properly. I can make a macro say for the first tab, which might have 50 rows of data, but then the second tab may have 200. The macro was only recorded for 50 rows. How can I do a sub total for each sheet, and have it know to proces...

Exchange 2007 And Daylight Savings Time Update
Is there a patch I need for Day light savings time and Exchange 2007? Thanks! No CDO patch required (no equivalent of KB 926666). However, the Windows Server 2003 OS will required KB 931836 time zone update and Calendar-items in 2007-hosted mailboxes created using old DST 2006 rules will need to be rebased. -- Bharat Suneja MVP - Exchange NEW blog location: ---------------------------------------------- "D303M" <> wrote in message > I...

when I save an email, where does it save to?
Hi all, I have several emails that I wanted to reply, and I did click "reply" and then wrote something, but I did not have time to finish... then I click on "save", and in the evening, I closed the outlook because I slept... now I reopen the outlook in the morning, and I want to find my saved unfinished replies that I was writing... But where to find them? I have a "draft" folder, but those saved emails do not seem to be in this folder... wherelse could they go? ---------------------------------------------- This is annoying... is there a way to automat...

Daylight Savings Time #2
In regards to DST or better yet XDST, in my windows 2003 domain environment I have the servers and workstations syncing their clock with one of my DCs. The statement has been presented here that since this is the case we should not have to worry about clocks being off by one hour. I do not get the warm and fuzzy with this statement. I feel that if it were that easy it would have been documented as a solution by now. Maybe they are right and I am wrong. Could you give me an explanation why so or why not? Thanks - Any clock synching is done based on UMT/GMT and the locale/timezone o...

Personal macros file
I keep a number of blocks of code in my personal.xls startup file just to have them readily at hand and perform routine tasks more quickly (and sometimes to save bits that were hard to figure out how to do). My company has chosen a somewhat chaotic approach to transitioning staff/depts from Excel 2003 to 2007, resulting in my needing to have both application versions on my PC at the same time. Believe me, I KNOW this is not recommended. So, here is my question. I've succeeded in creating one personal.xls file in my startup folder that opens for either application - though...

Automatic save of all messages from a known contact
Hi, I'd like to store automatically all messages from a known CRM Contact. If for example my customers email-address is, I'd like to store automatically all his emails via the Exchange<->CRM Connector regardless to who they are sent to. Is that possible? regards Juergen Tolksdorf Hi Juergen. My company has a product called Effective Email that does exactly what you are asking for. There is a sync event that gets installed on the users inbox. When emails come in, it checks the senders address against the CRM database, and if a match exists, it creates a...

Macro #52
Excel 2002. I have created a macro that runs a complex autofilter (using create macro function), and assigned it to a command button. Filter selects rows with a date either 31/12/2004 or 31/03/2005 ( 168 out of 336 rows ) Sub Period2() ' ' Period2 Macro ' Macro recorded 17/10/2005 by NWCSQARC ' ' Keyboard Shortcut: Ctrl+r ' Sheets("Last_4_Separate").Select Selection.AutoFilter Field:=2, Criteria1:="=31/12/2004", Operator:=xlOr, _ Criteria2:="=31/03/2005" End Sub If I run the macro using the command button or the short ...

Custom Lists
I use Excel in Spanish but I need to insert days of the week in english. That is why I created two custom lists, one goes from Monday to Friday and the other one from Monday to Sunday. But when I write Monday in a cell and select to fill series, Excel automatically inserts only the last list I created. How can I differentiate one from the other? Thanks in advance Regards, Emece.- ...