PC Review


Reply
Thread Tools Rate Thread

How to create a standard Quick Launch menu in Excel 2007

 
 
Lasse
Guest
Posts: n/a
 
      21st Oct 2008
Hi

How do I create a Quick Launch menu in Excel 2007 that will be shown each
time I start Excel 2007?

I have created one in Word 2007 by creating a .dotm file where I have added
the necessary macros to the Quick Launch menu and placing it in the START
folder. If I do the same with the Personal.xlsb it doesn't work.

/Lasse
 
Reply With Quote
 
 
 
 
Ron de Bruin
Guest
Posts: n/a
 
      21st Oct 2008
Hi Lasse

Maybe you like this menu
http://www.rondebruin.nl/qat.htm

Or see
http://www.rondebruin.nl/imageqat.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Lasse" <(E-Mail Removed)> wrote in message news:7054A5EF-0B65-4F21-BC2A-(E-Mail Removed)...
> Hi
>
> How do I create a Quick Launch menu in Excel 2007 that will be shown each
> time I start Excel 2007?
>
> I have created one in Word 2007 by creating a .dotm file where I have added
> the necessary macros to the Quick Launch menu and placing it in the START
> folder. If I do the same with the Personal.xlsb it doesn't work.
>
> /Lasse

 
Reply With Quote
 
Lasse
Guest
Posts: n/a
 
      22nd Oct 2008
Hi Ron

Thanks for your reply.

I have actually seen your site and tried your add-in. I am not interested in
a drop-down add-in, I am interested in adding a button for each macro in the
QAT. I have no problem doing this in Word 2007, just add the macros to the
Personal template.

After some trial and error I have found out that I can create a
Personal.xlsb containing all the macros and forms and then create a add-in
(Add-in.xlam) where I have customized the QAT and inserted the macros as
buttons from the Personal.xlsb. My only problem is that it looks like I have
to create a new Add-in.xlam each time I need to change or add buttons to the
QAT.

/Lasse

"Ron de Bruin" wrote:

> Hi Lasse
>
> Maybe you like this menu
> http://www.rondebruin.nl/qat.htm
>
> Or see
> http://www.rondebruin.nl/imageqat.htm
>
>
> --
>
> Regards Ron de Bruin
> http://www.rondebruin.nl/tips.htm
>
>
> "Lasse" <(E-Mail Removed)> wrote in message news:7054A5EF-0B65-4F21-BC2A-(E-Mail Removed)...
> > Hi
> >
> > How do I create a Quick Launch menu in Excel 2007 that will be shown each
> > time I start Excel 2007?
> >
> > I have created one in Word 2007 by creating a .dotm file where I have added
> > the necessary macros to the Quick Launch menu and placing it in the START
> > folder. If I do the same with the Personal.xlsb it doesn't work.
> >
> > /Lasse

>

 
Reply With Quote
 
Ron de Bruin
Guest
Posts: n/a
 
      22nd Oct 2008
Hi Lasse

Create the QAT you want in a new workbook
http://www.rondebruin.nl/imageqat.htm

See this section
How do you customize the QAT for one workbook

After that save the workook as a add-in



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Lasse" <(E-Mail Removed)> wrote in message news:9E5AD512-BFF9-46E1-B856-(E-Mail Removed)...
> Hi Ron
>
> Thanks for your reply.
>
> I have actually seen your site and tried your add-in. I am not interested in
> a drop-down add-in, I am interested in adding a button for each macro in the
> QAT. I have no problem doing this in Word 2007, just add the macros to the
> Personal template.
>
> After some trial and error I have found out that I can create a
> Personal.xlsb containing all the macros and forms and then create a add-in
> (Add-in.xlam) where I have customized the QAT and inserted the macros as
> buttons from the Personal.xlsb. My only problem is that it looks like I have
> to create a new Add-in.xlam each time I need to change or add buttons to the
> QAT.
>
> /Lasse
>
> "Ron de Bruin" wrote:
>
>> Hi Lasse
>>
>> Maybe you like this menu
>> http://www.rondebruin.nl/qat.htm
>>
>> Or see
>> http://www.rondebruin.nl/imageqat.htm
>>
>>
>> --
>>
>> Regards Ron de Bruin
>> http://www.rondebruin.nl/tips.htm
>>
>>
>> "Lasse" <(E-Mail Removed)> wrote in message news:7054A5EF-0B65-4F21-BC2A-(E-Mail Removed)...
>> > Hi
>> >
>> > How do I create a Quick Launch menu in Excel 2007 that will be shown each
>> > time I start Excel 2007?
>> >
>> > I have created one in Word 2007 by creating a .dotm file where I have added
>> > the necessary macros to the Quick Launch menu and placing it in the START
>> > folder. If I do the same with the Personal.xlsb it doesn't work.
>> >
>> > /Lasse

>>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Folders in Quick Launch as Menu Asif Razzaq Attari Windows XP General 2 24th Feb 2008 01:56 PM
Quick Launch context menu Wannes Microsoft Windows 2000 Group Policy 0 12th Jan 2005 10:48 AM
Start Menu & Quick Launch Sido Windows XP General 1 14th Sep 2004 04:26 AM
Quick Launch Menu Size John Dixon Windows XP Customization 2 13th Nov 2003 12:26 AM
ANN: True Launch Bar is a Superior replacement for standard Quick Launch. Yuri Kobets Freeware 1 28th Oct 2003 12:41 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:28 PM.