Esc to clear Sheet

[ottagosoon]

I set up a macro to preview a work sheet on sheet 3 and when I right click it clears the sheet and sends me back to sheet 1. The problem is that when I get back to sheet 1 I have the drop down box with copy, paste and all that displayed. I have to hit the Esc button or a cell on the sheet to remove it. Is there some way of including the Esc in the macro to clear the drop down box?

[mudraker]

Perhaps try Sendkeys

Please Login or Register  to view this content.

[ottagosoon]

It worked but had to set it to False. The box flashed up and then is gone. I tried the
'Turn off screen updating
Application.ScreenUpdating = False
To see if it would hide it but it still just a flash and that is far better then it was.

Thanks

[davesexcel]

here is an example code for you

Please Login or Register  to view this content.

the cancel=true stops the right click menu from showing

[ottagosoon]

Cancel=True did the trick
Thanks,