I don't think it's a feature or a bug.

I've never seen the problem in real life and I've never seen any post that
describes this situation as a bug--except for this thread.

MichaelW wrote:

It's a password to open the file - apparently its a feature (spelt BUG) - see
other postings. many thanks for contribution

"Dave Peterson" wrote:

What password did you use to protect the opening of the file--password to open
or password to modify?

If you used password to open, then I don't have a guess.

But if you used password to modify, I'm betting that this user doesn't have
write access to the drive/folder that contains your file. And excel/windows
work together and notice that and just open the file in read-only mode. (Do you
see [Read-Only] in the title bar?)



MichaelW wrote:

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 ?

--

Dave Peterson


--

Dave Peterson