Lock File Name

[Av8tordude]

Is it possible to prevent the user from changing the file's name?

 

[Smitty]

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"...

The trick with sneaky users is not teaching them anything lest they get wise!

Unfortunately it ain't the sneaky ones you have to worry about here.

 

[Av8tordude]

Thank you for your help.