Av8tordude
Well-known Member
- Joined
- Oct 13, 2007
- Messages
- 1,036
Is it possible to prevent the user from changing the file's name?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Lock File Name
- Thread starter Av8tordude
- Start date
Smitty
Legend
- Joined
- May 15, 2003
- Messages
- 29,536
Not really, unfortunately.
You can use the open event to test for the wb name I suppose and resave it if it's changed, and the before save event to make sure it's not saved as something else, but it can be defeated by disabling macros. One of the inherent problems with any file I suppose.
Without network file control/permissions, there's nothing keeping a user from renaming a file, but you need to have a pretty good relationship with IT to do that, and that often comes at the cost of pissing off users because their abilities become limited.
I ran into it all the time at my last job with dipschnzit users who just couldn't grasp that certain files needed to be named a certain way for code to work...
I can't tell you how many "it doesn't work anymore" calls I used to get because some dumba$$ renamed a file "Dumb User's Name Call Report"...
Unfortunately it ain't the sneaky ones you have to worry about here.
You can use the open event to test for the wb name I suppose and resave it if it's changed, and the before save event to make sure it's not saved as something else, but it can be defeated by disabling macros. One of the inherent problems with any file I suppose.
Without network file control/permissions, there's nothing keeping a user from renaming a file, but you need to have a pretty good relationship with IT to do that, and that often comes at the cost of pissing off users because their abilities become limited.
I ran into it all the time at my last job with dipschnzit users who just couldn't grasp that certain files needed to be named a certain way for code to work...
I can't tell you how many "it doesn't work anymore" calls I used to get because some dumba$$ renamed a file "Dumb User's Name Call Report"...Unfortunately it ain't the sneaky ones you have to worry about here.
Upvote
0
