Get AutoCorrect Options with VBA

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

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

Sherry

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




.
 
S

Sherry

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




.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top