Hi everybody!
I'd like to know how can I stop warning messages in Excel from being displayed. I am particularily intrested in the message reffering to the protected cells.
Any idea would be welcome!
Dorel
Stopping warning messages
-
-
-
-
Re: Stopping warning messages
Thanks for your answer, Max!
In the protected worksheet case, the message displays at doubleclick event, so I put the instruction you indicated in the Worksheet_BeforeDoubleClick procedure, but it doesn't block the message.CodePrivate Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Application.DisplayAlerts = False End Sub
Can I try something else?Thank you!
Dorel -
Re: Stopping warning messages
I'm sorry my friend but I know of nothing that disables that warning. If there were, I would be using it myself... I'm not a fan of that warning either.
-
Re: Stopping warning messages
Hi,
If all you want to do is supress the message try this[vba]Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Cancel = TRUE
End Sub [/vba] -
-
-
Re: Stopping warning messages
Thank you, Andy!
It works fine!
Dorel
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!