shared on a server

[jeff]

can an excel workbook document be shared on a server at the same time, even though the workbook has macros that protect and unprotect cells.

 

[Dave Peterson]

Take a look at "features that are unavailable in shared workbooks" in excel's
help.

You'll see that you can't change worksheet or workbook protection.