Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2004
    Posts
    78

    Question Unanswered: Copy/Paste Problem

    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

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    This is not a sheet-specific macro because it affects the workbook.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Also remember that one can always disable macros and skirt the issue entirely. Not to mention saving the whole thing as text.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  4. #4
    Join Date
    Dec 2004
    Posts
    78
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •