not quite what I wanted. The reason why I want this feature is I want to stop users from making coping of the master file stored in our internet portal. I have a before_save macro to disable some function rendering it useless. But this macro won't work if a user can turn off the macro and save a copy in their own drive.
If "turned on" to you means Enabled, then yes it does, which I said twice last night is not possible to control, and others have told you the same thing last night and now again here tonight:
Tom Urtis said:
Security (such as it is) is handled at the local (computer) level, and if someone wants to make a copy of the workbook they will, in Explorer or other ways that are easily available totally outside of the workbook author's control.
Thne I gave you directions and code to take the macros out of a file and make a copy of that file so it has no code in it. That way you won't have to worry about th euser's security settings because the file you are sending them has no code, which you originally asked about.
Beyond that, maybe you need a platform other than Excel.