Hi

I've seen other threads discussing how to unprotect and then protect a worksheet in a macro - and how this can't be done in a shared workbook.

I need to be able to date stamp the spreadsheet - and the only way I know how to do this is to enable track changes on the workbook. This then shares the workbook. My macro unprotects the worksheet, modifies it then protects it again. The worksheet protection is a necessity. Is it true that there is no way to protect/unprotect a worksheet when the workbook is shared?

Either I solve the above problem, or I find a different way of date stamping the spreadsheet - any ideas anyone?

Thanks in advance
James