I have an Excel application that contains macros. On opening the user gets
prompted to enable macros (security level set to medium). On enable macros
the user is prompted for a file password, followed by entering their
individual username and password ( controlled by my macros). This is correct.
I have an end user that although setting the security level to medium doesn't
get the macro security level message on opening, but goes straight to the
file password - this means that the macros have not been enabled and the
application fails.

Is the problem with my application or his excel ?