Get AutoCorrect Options with VBA

  • Thread starter Thread starter Sherry
  • Start date Start date
S

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.
 
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.)
 
Dave, works like a charm. Thank you very much!

Dave Peterson said:
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.)




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

Dave Peterson said:
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.)




.
 
Back
Top