Protected worksheet, shared workbook problems

  • Thread starter Thread starter mika.
  • Start date Start date
M

mika.

I'm in quite the fix. I'm using XL2000 and
1. I have a shared workbook
2. ...that I want certain data protected
3. ..but I also want users to be able to insert rows.

2 and 3 together are not a problem because thanks to
someone's suggestion, I insert rows via a macro where the
macro first unprotects the data, then reprotects the
correct data. 1, 2, and 3 is a problem since when a
workbook is shared, you can't unprotect data and thus I
can't do 2 and 3 if the workbook is shared.

Is there anyway I can use my insert rows macro without
having to unshare the workbook?

Thanks so much.
 
Back
Top