We had this discussion last night, and since then Excel has not changed.hon said:Just want to find out if it is possible to force Excel to turn on macro when open.
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.
Tom Urtis said:there are no guarantees against piracy, intranet or not, and especially not possible to control the macro security settings of one computer from another.
This is no way to prevent a user from disabling macros, or a macro enabling macros. If this was possible then virus's could easily infect your system :wink: