Password box not appearing

[louiserace]

I work in a school and I have created a spreadsheet that asks for a password to allow people to modify it but will allow read only for anyone else.

However, for some people this box is not appearing and the spreadsheet is opening directly as read only.

Any clues as to how to solve this would be helpful.

 

[6StringJazzer]

It appears that you are using VBA and a custom UserForm to do this. Remember that none of this will happen if the user has not enabled VBA.

Please show all your code and tell us what module(s) it is in.

 

[RoryA]

@6StringJazzer
That's a built-in dialog, Jeff, not a userform.

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Password box not appearing
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[6StringJazzer]

@6StringJazzer
That's a built-in dialog, Jeff, not a userform.

Oh, whoops. Sorry. In that case I don't have an answer.

 

[louiserace]

I have now found out that this is due to folder access to the where the spreadsheet is saved.