Re: compile error: invalid qualifier.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



did you omit the period in front of show or was it removed by the email
software

With application.Dialogs(xlDialogOpen)
.Show
End With

--
Regards,
Tom Ogilvy

"MGG" <MGG.1t3nel_1122923129.9385@xxxxxxxxxxxxxxxxxxxxx> wrote in message
news:MGG.1t3nel_1122923129.9385@xxxxxxxxxxxxxxxxxxxxxxxx
>
> Can anyone help?
>
> I keep getting an the following message
> Compile error: invalid qualifier
> when using the following code from a customised menu.
>
> With application.Dialogs(xlDialogOpen)
> Show
> End With
>
>
>
> If I use this code and link it to a button it works fine ???
>
> Thanks
> Mike
>
>
> --
> MGG
> ------------------------------------------------------------------------
> MGG's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=25789
> View this thread: http://www.excelforum.com/showthread.php?threadid=391910
>


.


Quantcast