+ Reply to Thread
Results 1 to 4 of 4

Disable cut, copy, paste and force enable macros

  1. #1
    Registered User
    Join Date
    11-11-2009
    Location
    detroit
    MS-Off Ver
    Excel 2007
    Posts
    14

    Disable cut, copy, paste and force enable macros

    Hello friends,

    I am trying to disable cut copy paste and force enable macros in my worksheet, I have the following code that disables cut copy paste but I need help to force enable macros. I did search the forum and found a few codes but I always end up getting errors. The following is my cut copy past code.

    Please Login or Register  to view this content.


    Thank you
    Last edited by abhinavn; 04-20-2011 at 03:03 PM. Reason: Solved

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    38,140

    Re: Disable cut, copy, paste and force enable macros

    You can't "force enable" macros. If you could, it would defeat the object of the security options and facilitate malicious code.

    You have options though; you could digitally sign your code or you could make your workbook unusable if macros are not enabled. You would do this by creating and displaying only a "splash" screen which informs users they need to reload the workbook and enable macros. All other sheets would be set to "very hidden" and the VBA code protected.

    It's a relatively common question so you should be able to find lots of examples.

    Regards
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    11-11-2009
    Location
    detroit
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: Disable cut, copy, paste and force enable macros

    Hello TMShucks,

    Thank you for your response I found a few and added the following code
    Please Login or Register  to view this content.

    Can you please tell me what I am missing.

    Thank you
    Last edited by abhinavn; 04-20-2011 at 02:59 PM.

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    38,140

    Re: Disable cut, copy, paste and force enable macros

    Not really. I'd need to see this in the context of a sample workbook.

    Please note that, if you post code, you should enclose it in CODE Tags.

    The Forum Moderators are particularly keen to ensure the Forum rules are complied with.

    Regards

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1