If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
copy quick access toolbar
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)? |
Thread Tools | |
Display Modes | |
|
|