+ Reply to Thread
Results 1 to 2 of 2

Running Macro and Worksheet Change on PROTECTED Sheet?

  1. 09-03-2015, 09:59 AM #1
    ksayet
    ksayet is offline
    Registered User
    Join Date
    11-23-2013
    Location
    new york, ny
    MS-Off Ver
    Excel 2010
    Posts
    42

    Running Macro and Worksheet Change on PROTECTED Sheet?

    Hello!

    I'd like all three macros to work below on a protected sheet... Is that possible? I get an error each time I try to run it while protected. How can I work around that?

    add row with new employee
    Please Login or Register  to view this content.

    Delete row of selected employee
    Please Login or Register  to view this content.


    Sort when there is a change:
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 09-03-2015, 10:16 AM #2
    pjwhitfield
    pjwhitfield is offline
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: Running Macro and Worksheet Change on PROTECTED Sheet?

    turn off the protection at the start of the Macro and turn it back on at the end using
    Please Login or Register  to view this content.
    If someone has helped you then please add to their Reputation
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Running Macro and Worksheet Change on PROTECTED Sheet?
    By ksayet in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-03-2015, 01:07 PM
  2. Running Macro and Worksheet Change on PROTECTED Sheet?
    By ksayet in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-03-2015, 10:58 AM
  3. Running Macro and Worksheet Change on PROTECTED Sheet?
    By ksayet in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-03-2015, 09:36 AM
  4. running a macro on protected worksheet
    By gryffin13 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-10-2015, 09:24 AM
  5. Running Macro on protected worksheet
    By pdmkh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-16-2011, 10:32 AM
  6. running a macro on a protected worksheet
    By smithy_o7 in forum Excel Programming / VBA / Macros
    Replies: 38
    Last Post: 06-21-2010, 06:45 AM
  7. running Macro on a Protected Worksheet
    By Martha in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-06-2008, 02:29 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1