Running Macro and Worksheet Change on PROTECTED Sheet?

[ksayet]

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.

[Aardigspook]

Hi,

Put this at the start of your macro:
ActiveSheet.Unprotect "xyz"
and this at the end:
ActiveSheet.protect "xyz", True, True
where 'xyz' is your password

Regards,
Aardigspook

If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark Thread as Solved'.
You don't need to give me rep if I helped, but thanks are appreciated.