Hi,
I'm trying to add a macro that when the user tries to save, forces them to use a certain file name.
What I'm trying to achieve is:
- get file name from cells in spreadsheet (picks up month and version number)
- prompt user to make sure they've updated the version number.
- If not, allow them to cancel save
- If yes, save the file with the appropriate month and version number
The problem is that everything runs fine without that last line. As soon as I add the line, it causes Excel to crash. I know I'm missing something really obvious. Any ideas?![]()
Please Login or Register to view this content.
Bookmarks