Enable Mouse's right button Menue & WS editing while Userform running

**wali** · 12-05-2009, 07:39 AM

Hello,

I have a User Form which i want to use in such a way that editing the worksheet directly is not disabled while the userform is running. I would also like to use the right button mouse menu(cut, cpy,paste) while i am using the user form. I am using two Monitors with my PC and i want to work with User Form on one monitor being able to edit worksheet without having to close my User Form.

Is it possible to have a code which I can also use for other User Forms and other files doing the same job?

Thanks for each assistance in advance.

**davesexcel** · 12-05-2009, 08:00 AM

This site should give you some info on how to do this, in your UserForm properties set ShowModal=False should enable you to work with the sheet.
http://support.microsoft.com/kb/215861