Greetings from Salina, Ks,
I have a worksheet for other users in our office that is worksheet protected for obvious reasons. Complete access to the worksheet has proved fatal. We keep the worksheet protected to maintain the formulas & formatting.
This protection disables the users ability to add cell comments which would be very helpful in this worksheet.
Is there simple code to create a macro that would :
1. password unprotect worksheet
2. Prompt user for cell comment
3. Password protect sheet upon completion of user entering cell comment?
Any help would be appreciated.
mweaver
I have a worksheet for other users in our office that is worksheet protected for obvious reasons. Complete access to the worksheet has proved fatal. We keep the worksheet protected to maintain the formulas & formatting.
This protection disables the users ability to add cell comments which would be very helpful in this worksheet.
Is there simple code to create a macro that would :
1. password unprotect worksheet
2. Prompt user for cell comment
3. Password protect sheet upon completion of user entering cell comment?
Any help would be appreciated.
mweaver