rdedwards13
New Member
- Joined
- Nov 23, 2016
- Messages
- 4
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!
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!