I am using the following code to enable and disable copy/paste in my worksheets.

http://xcelfiles.homestead.com/VBA_Quick13.html

The problem is if I open multiple worksheets and disable copy on one of the worksheets, it disables copy on all other worksheets too. Is there a way so that I can enable or disable copy/paste only on the worksheet I wish. All my worksheets have only one sheet.

Thank you.

~BS

I guess the "quick-hack" answer is to enable and disable the functions for ONLY the worksheets you need disabled through event driven subs...

Can you please elobrate or give example of the code.

Thanks.

~BS