invoke Worksheet_Change when the sheet is protected...

  • I'm using the following (works well, but doesn't trigger when the sheet is protected):




    thank you.

  • Re: invoke Worksheet_Change when the sheet is protected...


    Something like this perhaps?



    [SIZE=3]The Only Dumb Question Is A Question Not Asked.[/SIZE]

  • Re: invoke Worksheet_Change when the sheet is protected...


    Yegarboy


    Your code switches screen updating off, but does not switch it back on.


    mjschukas


    You can also use Protect with UserInterfaceOnly

  • Re: invoke Worksheet_Change when the sheet is protected...


    Hey Roy,


    Not my code lol..I only added a snip to unprotect and protect his code. I used his code as a reference :)

    [SIZE=3]The Only Dumb Question Is A Question Not Asked.[/SIZE]

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!