That's as far as you can get with code. Selections from submenus like that
can't be automated unless you use SendKeys, and that's not all that
reliable.
"M Shafaat" <poppy2@comhem.se> wrote in message
news:evGv4P68KHA.3176@TK2MSFTNGP05.phx.gbl...
> Hi Ken,
> Thank you very much for your reply, which helps me, even if not whole the
> way. The code displays the menu for Paste Special, while I want to perform
> "Paste Special/Plain Text" without having to do anything else that
> activating the macro.
>
>
>
> Is there a way to do that?
> Thanks again for your help.
> Regards
> M Shafaat