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: 1
Default XLSM File Will Not Save Macros in Quick Access Toolbar

I have a workbook with several macros to automate repetitive tasks. The tasks
are so repetitive that I added the macros to the Quick Access Toolbar. I
added the buttons "for this workbook only", because I don't need them in
every workbook (and they aren't available in any other workbooks). I save the
file, close it, and re-open it. I then see that the "this workbook only" part
of the QAT is completely gone.

I assume this is a bug, because if it were by design, then there would be no
point in allowing macros to be added to the toolbar. Also, I have added
macros to QATs on other computers. The problem seems limited to my computer.
The problem is NOT limited to one workbook; I can reproduce the issue at will
with any XLSM file.

Many internet searches have yielded no help. Does anyone have any ideas?

Thank you.
 
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
Losing Customizations On Quick Access Toolbar When I Reopen File William Excel Discussion (Misc queries) 2 June 17th 09 03:22 AM
Quick Access Toolbar dbs Excel Discussion (Misc queries) 2 July 4th 08 04:02 PM
Quick Access Toolbar File Mary Fetsch Excel Discussion (Misc queries) 4 March 3rd 08 01:42 PM
File name in Quick Access Toolbar Maureno Excel Discussion (Misc queries) 4 October 31st 07 06:05 PM
quick access toolbar Jan Excel Discussion (Misc queries) 3 March 22nd 07 11:35 AM


All times are GMT +1. The time now is 10:10 AM.

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

About Us

"It's about Microsoft Excel"