Save AutoCorrect entry to workbook?

[rdedwards13]

I have a question about AutoCorrect - I know that custom entries are saved to the local computer's normal.dotm file, but is it possible to save a custom entry to an individual workbook instead of a different file on the user's computer? Or is there a way that when the excel workbook is opened, that it can check to see if the desired AutoCorrect entry exists, and if not, add it to the user's computer?

I have a file that I use for my job, which I share with many other users around the country who are in my same field. Being able to automatically add the desired AutoCorrect entry to the worksheet, OR adding it to the user's normal.dotm file when the workbook is opened, would save the time of having to walk each person through how to add an AutoCorrect entry.

FYI - I am looking to replace the word "lock" with "?" (without quotes). If needed, the Hex & Decimal codes for the icon can be found here: Unicode character inspector: ?.

I would prefer to avoid using VBA/Macro to do this, but if that is the only way, then any assistance in achieving this would be GREATLY appreciated!

 

[Norie]

Pretty sure Excel AutoCorrect entries aren't save to the Normal Word template.

As far as I know in Excel the AutoCorrect entries are application wide set via Options>Proofing...

 

[rdedwards13]

You're correct in that I referred to the wrong location of where AutoCorrect entries are saved. I guess that's what happens when I'm working the day before Thanksgiving .

I'm just trying to figure out how to manually add this custom AutoCorrect entry (replace the word "lock" with "��") to another user's computer when the workbook is opened. Sorry for any confusion.

 

[rdedwards13]

CORRECTION: replace the word "lock" with "?" (without quotes).

 

[Norie]

You can add/delete AutoCorrect entries in Excel using Application.AutoCorrect.AddReplacement and Application.AutoCorrect.DeleteReplacement respectively.

Not sure how you would handle the �� though.

 

[rdedwards13]

Thank you Norie. Would it be as simple as entering this into VBA? I assume that the HEX or DEC codes for ? would have to be used instead of the lock icon itself?

With Application.AutoCorrect
.AddReplacement "lock", "?"
End With

 

[Norie]

VBA won't accept ��, it just turns it into ??.

So I'm not sure how you would enter a symbol, can you enter the lock symbol using the keyboard?