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.

[Kenneth Hobson]

For the sheet's Protect set the UserInterfaceOnly value to True. Or, Protect the sheet, other code, and Unprotect the sheet.

I set all my sheet protection in ThisWorkBook object. Change ken to your password. When the workbook opens, the passwords are set and code can then edit away.

Please Login or Register  to view this content.