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

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
(E-Mail Removed)HIS


<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>

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