Software

I am unaware of a method to do as you specifically ask. One possible work-around is to Protect and Share the file with a password (Tools menu | Protect | Protect and Share Workbook). That way only those users with the password can modify.

I'mnot sure, however, that meets your needs.

Al Hedstrom

I have run into the same problem. I built the protect and unprotect into my macro as a work around. I created my document and protected it, but when I built my macro the first thing I had it do was unprotect the sheet and the last thing I had it do was protect it again. I hope this helps!