Get AutoCorrect Options with VBA

[Sherry]

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.

 

[Dave Peterson]

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.)

 

[Gary Keramidas]

dave

works in 2007 and 2010

 

[Dave Peterson]

Thanks Gary.

 

[Sherry]

Dave, works like a charm. Thank you very much!

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.)




.

 

[Sherry]

Dave, it works like a charm. Thank you very much

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.)




.