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

Opening a dialog
 

Fredrik

You may get some info here

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

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

"Fredrik Wahlgren" wrote in message
...
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

Opening a dialog
 

To add to Nick's excellent page:

application.Dialogs(xlDialogAddinManager).Show

--
Regards,
Tom Ogilvy

"Fredrik Wahlgren" wrote in message
...
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

Opening a dialog
 

Nick and tom, Thank you

/Fredrik