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.

[BellyGas]

You need to protect the sheet(s) with the switch: userinterfaceonly = true.

This tells Excel to allow VBA to make changes, only disallowing the user to via the UI (user interface). However, you need to set this switch every time the workbook is opened as Excel will forget you've done this. In the workbook_open event put some code to unprotect all your worksheets and then protect again with the userinterfaceonly = true switch.