+ Reply to Thread
Results 1 to 4 of 4

Code to be activated when user Move or Copy a Sheet

  1. #1
    Registered User
    Join Date
    04-01-2011
    Location
    Manila, Philippines
    MS-Off Ver
    2019
    Posts
    53

    Code to be activated when user Move or Copy a Sheet

    Hi

    How can I run a macro when the user tried to move or copy a sheet (which can be accessed by selecting the sheet > right click > move or copy)?

    Regards,
    Batman07
    Simply hit the star button to say THANK YOU.

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Code to be activated when user Move or Copy a Sheet

    there's no event specific to that. what are you trying to do?
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Registered User
    Join Date
    04-01-2011
    Location
    Manila, Philippines
    MS-Off Ver
    2019
    Posts
    53

    Re: Code to be activated when user Move or Copy a Sheet

    I would like to prevent the user from using that feature. I'm using excel 2010.

  4. #4
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Code to be activated when user Move or Copy a Sheet

    then I reckon you'll need to alter the customui of your workbook to disable that command.

+ 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