Prev: X = SHELL
Next: Cracking VBAProject Password
From: Sherry on 15 May 2010 21:19
Is there a way to "call" the AutoCorrect Dialog box programatically in Excel
2007? This would be the same as selecting the Office Button, Excel Options,
Proofing, AutoCorrect Options. I tried to record those steps but that doesn't
work.

Thanks.
From: Dave Peterson on 15 May 2010 21:36
I didn't test this in xl2007, but it worked in xl2003:

Application.Dialogs(xlDialogAutoCorrect).Show

It shouldn't take too long for you to try it.

Please post your results. (I'm curious.)



On 05/15/2010 20:19, Sherry wrote:
> Is there a way to "call" the AutoCorrect Dialog box programatically in Excel
> 2007? This would be the same as selecting the Office Button, Excel Options,
> Proofing, AutoCorrect Options. I tried to record those steps but that doesn't
> work.
>
> Thanks.
From: Gary Keramidas on 15 May 2010 21:51
dave

works in 2007 and 2010


--


Gary Keramidas
Excel 2003


"Dave Peterson" <petersod(a)XSPAMverizon.net> wrote in message
news:ev2WBhJ9KHA.5412(a)TK2MSFTNGP06.phx.gbl...
>I didn't test this in xl2007, but it worked in xl2003:
>
> Application.Dialogs(xlDialogAutoCorrect).Show
>
> It shouldn't take too long for you to try it.
>
> Please post your results. (I'm curious.)
>
>
>
> On 05/15/2010 20:19, Sherry wrote:
>> Is there a way to "call" the AutoCorrect Dialog box programatically in
>> Excel
>> 2007? This would be the same as selecting the Office Button, Excel
>> Options,
>> Proofing, AutoCorrect Options. I tried to record those steps but that
>> doesn't
>> work.
>>
>> Thanks.

From: Dave Peterson on 16 May 2010 07:33
Thanks Gary.

On 05/15/2010 20:51, Gary Keramidas wrote:
> dave
>
> works in 2007 and 2010
>
>
From: Sherry on 16 May 2010 14:26
Dave, works like a charm. Thank you very much!

"Dave Peterson" wrote:

> I didn't test this in xl2007, but it worked in xl2003:
>
> Application.Dialogs(xlDialogAutoCorrect).Show
>
> It shouldn't take too long for you to try it.
>
> Please post your results. (I'm curious.)
>
>
>
> On 05/15/2010 20:19, Sherry wrote:
> > Is there a way to "call" the AutoCorrect Dialog box programatically in Excel
> > 2007? This would be the same as selecting the Office Button, Excel Options,
> > Proofing, AutoCorrect Options. I tried to record those steps but that doesn't
> > work.
> >
> > Thanks.
> .
>
 |  Next  |  Last
Pages: 1 2
Prev: X = SHELL
Next: Cracking VBAProject Password