Opening a dialog

Hi

How can I write a macro that simply opens a form such as Tools|Add-ins? I
don't want to make a selection, I just want to open it.

TIA,
Fredrik

Fredrik

You may get some info here

http://www.nickhodge.co.uk/tipstrick...builtindialogs

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS

"Fredrik Wahlgren" <fredrik.p.wahlgren@mailbox.swipnet.se> wrote in message
news:erbTaiLCFHA.1084@TK2MSFTNGP11.phx.gbl...
> Hi
>
> How can I write a macro that simply opens a form such as Tools|Add-ins? I
> don't want to make a selection, I just want to open it.
>
> TIA,
> Fredrik
>
>

To add to Nick's excellent page:

application.Dialogs(xlDialogAddinManager).Show

--
Regards,
Tom Ogilvy

"Fredrik Wahlgren" <fredrik.p.wahlgren@mailbox.swipnet.se> wrote in message
news:erbTaiLCFHA.1084@TK2MSFTNGP11.phx.gbl...
> Hi
>
> How can I write a macro that simply opens a form such as Tools|Add-ins? I
> don't want to make a selection, I just want to open it.
>
> TIA,
> Fredrik
>
>

Nick and tom, Thank you

/Fredrik