I've created a Purchase Order form in Excel 97. One problem I've
encountered is that the Autocorrect-"Replace text as you type" action
is on by default. Hence when a user tries to enter the vendor "FWE"
it automatically gets changed to "FEW". Is there a way I can turn the
"replace text as you type" function off from within the macro?

--
BrianG

Here you go:

Application.AutoCorrect.ReplaceText = False

Use it in good health. - Piku

--
Message posted from http://www.ExcelForum.com

Application.AutoCorrect.ReplaceText = False

Wow, too easy. Do I need to change it back to "True" when I exit the
macro?

--
BrianG



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

I would

--
Message posted from http://www.ExcelForum.com

If you don't want it disabled.

--
Regards,
Tom Ogilvy

"BrianG" wrote in message
...

Application.AutoCorrect.ReplaceText = False

Wow, too easy. Do I need to change it back to "True" when I exit the
macro?

--
BrianG



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!