Copy/Paste Problem

bhavesh78 · #1 (**permalink**) 01-05-05, 19:21

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

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

Now the problem is that if I have multiple protected sheets opened and I disable copy/paste on one of the sheets, it disables it on all the sheets. Is there a way so that I can only disable it on only one sheet.

Thanks.

~BS

shades · #2 (**permalink**) 01-05-05, 20:27

This is not a sheet-specific macro because it affects the workbook.

Teddy · #3 (**permalink**) 01-06-05, 10:22

Also remember that one can always disable macros and skirt the issue entirely. Not to mention saving the whole thing as text.

bhavesh78 · #4 (**permalink**) 01-06-05, 11:55

I am sorry. i meant workbooks. If I enable copy/paste on one workbook it enables it on all the workbooks. The code I am using is:

Code:

Private Sub Workbook_BeforeClose(Cancel As Boolean) 
        Call EnableCopyCutAndPaste
End Sub

Internet Services

Web Development

Digital Marketing

Consumer Tech