Show the Paste Names dialog via code

[Ted M H]

I'm trying to find the code to display the Paste Names dialog box. You can
usually get this to pop up with F3 when working in the standard user
interface in Windows versions of Excel.

I've tried the following code, which works just fine for some built in
dialog boxes, but errors out for Paste names:

Application.Dialogs(xlDialogPasteNames).Show

This statement results in the RunTime 1004 message.

If I change this to application.Dialogs(xlDialogDefineName).Show the Define
names dialog box pops right up.

Any ideas?

 

[Barb Reinhardt]

What exactly are you trying to do with this? It may be able to be done
another way.

Barb Reinhardt

 

[JLGWhiz]

If it is any consolation, I can't get it to open either. Maybe it has been
scrapped by MS. I checked the web for any previous bug reports and did not
see any. Haven't checked knowledge base yet.

 

[Ted M H]

Thanks for responding.

Actually, I need the equivalent of F3 for the Mac OS versions of Excel. It
just takes too much time to do Insert > Name > paste from the menu compared
to just doing F3 in the windows world.

My thought was that I could just write a simple macro to pop up the dialog
box and assign a short cut key to the macro. No such luck, so far.

I know this is the windows forum, but I think if I can get a macro to work
in windows I can then get it to work under the Mac OS versions. There just
aren't enough users at the Mac forum to get answers to obscure questions like
this one...