LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 12
Default Macros, Buttons & the XLB file.

Hey folks.

Looking for some help with a custom toolbar, I have three macros
stored on one spreadsheet, its contained within the XLstart file as it
should be. I've assigned each macro a custom button on a new toolbar.
Apart from the fact that you can't seem to move an XLB file to another
user's PC succcessfully it also seems that this particular user's
instance of Excel isn't saving the toolbar preferences when excel is
closed. (I'm told that the XLB file is updated each time excel is shut
down.)

I'm not a code expert, I'd prefer not to have to record the macros
again. I suppose my questions are thus:

A: Why would the XLB file not be getting updated on excel closure?

and

B: Why with the existing XLB file when any of the buttons are pressed
do they try to open the spreadsheet containing the macros and not run
them. (The sheet is already open, it being in the XLstart file.)

Being as I am a somewhat simple person, I'd appreciate any simple
answers you might have to offer. (As would our IT department as I'm
considering throwing my computer out of a window :-)

Thanks.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macros - copying macros from one computer to another TT Excel Discussion (Misc queries) 18 December 14th 06 03:24 AM
how do I email amacro? leo Excel Worksheet Functions 24 August 9th 06 02:47 PM
Macros AND Buttons [email protected] Excel Worksheet Functions 3 August 9th 06 09:03 AM
save excel file from a table delimited file (.txt) using macros sedamfo New Users to Excel 1 February 15th 05 04:19 AM
Weekly Transaction Processing Ralph Howarth Excel Worksheet Functions 4 January 19th 05 05:37 AM


All times are GMT +1. The time now is 07:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"