Sheet protection prompts

A

ajhil2

All,

Ive been building a speadsheet for data collection and have
incorporated event macros that format columns, filter and
protect/unprotect the worksheet.

One of the users is receiving a confirmation prompt each time the macro
protects/unprotects the sheet. I however am not being prompted on my
pc and have been unable to replicate this. Has anyone come across this
before and could you please advise how it can be overcome.

Would appreciate any assistance you can provide.

Regards,

Adrian
 
N

Nick Hodge

Not sure why this would happen to one user, unless they have a different
version possibly. Could you incorporate

Application.DisplayAlerts=False

Into you code at various places to suppress the dialog?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]
 
A

ajhil2

Thanks Nick. I tried this previously and later removed it since it
wasnt achieving the desired result (which confused me even further).
Ive since readded 'DisplayAlerts = False' back into all related macros
but still experiencing the same issue on some pcs (just not any that I
have immediate access to).

Thus I would appreciate any further ideas. Depsite the lack of effec
to date I might try adding 'DisplayAlerts = False' to that worksheet to
see if it has an effect.

Regards,

Adrian
 
Top