Suppress warning message

[ElvisSteel]

Hi,

I have a sheet on which I want the user to double click on a cell in order to trigger some code. I don't want the cell to be edited, so the cell is locked. When I double click on it, the code triggers OK, but I get the message:

"The cell or chart you are trying to change is protected...."

Is it possible to stop this message from appearing, I have tried setting Application.DisplayAlerts = False but this doesn't seem to work.

On a similar point, can the standard right-click menu also be disabled? (the one with Cut, Copy, Paste .... Hyperlink etc)

Thanks

Steve

 

[Jon von der Heyden]

Hello Steve

You can prevent a user from editing a cell with:

[COLOR=blue]Private[/COLOR] [COLOR=blue]Sub[/COLOR] Worksheet_BeforeDoubleClick([COLOR=blue]ByVal[/COLOR] Target [COLOR=blue]As[/COLOR] Range, Cancel [COLOR=blue]As[/COLOR] [COLOR=blue]Boolean[/COLOR])
    Cancel = [COLOR=blue]True[/COLOR]
[COLOR=blue]End[/COLOR] [COLOR=blue]Sub[/COLOR]

The message won't appear.

And the following to prevent right-click menu:

[COLOR="Blue"]Private[/COLOR] [COLOR="Blue"]Sub[/COLOR] Worksheet_BeforeRightClick([COLOR="Blue"]ByVal[/COLOR] Target [COLOR="Blue"]As[/COLOR] Range, Cancel [COLOR="Blue"]As[/COLOR] [COLOR="Blue"]Boolean[/COLOR])
    Cancel = [COLOR="Blue"]True[/COLOR]
[COLOR="Blue"]End[/COLOR] [COLOR="Blue"]Sub[/COLOR]

 

[ElvisSteel]

Thanks very much Jon,

I knew about "Cancel = True" but didn't think of using it after executing some code.

Works perfectly!