Hi,

I should add that you can create a custom QAT toolbar for each workbook
without playing with the Excel.QAT file. In the Customize tab of the Excel
Options dialog box, top right corner open the Customize Quick Access Toolbar
and choose your workbook. Add whatever tools you want to this workbook QAT.
What will happen is that IF there is room to display it, it will show to the
right of the default QAT.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Tim" wrote:

I've read that when I customize the quick access toolbar that this is saved
in a .qat file. Where is this file?

I've looked in the following location both for "All Users" and specific to
my user id:
C:\Documents and Settings\All Users\Application Data\Microsoft

In addition, I've done a search on *.qat with no result

Once I get the .qat file, can I save it for other apps or do I need to
customize each app (since some commands aren't in all apps i.e. functions)?