I notice that in Excel 2003 you can protect a sheet but have an option that
would continue to allow rows to be inserted. Is there a way to do this in
Excel 2000? When I protect the sheet then row inserts are no longer
allowed.

Thanks for any help.
Mike B


--
Disclaimer: Any comments made are personal and do not reflect the thoughts
or policies of this company.

Hi Mike,
You can insert the rows with a macro, as long as the macro
turns off protection. You do not need a password for protection
but if you do, then the macro would have to use that password.
For macros to insert rows see
http://www.mvps.org/dmcritchie/excel/insrtrow.htm

For the code for protection off and on, record a macro.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Mike Bennett" wrote in message ...
I notice that in Excel 2003 you can protect a sheet but have an option that
would continue to allow rows to be inserted. Is there a way to do this in
Excel 2000? When I protect the sheet then row inserts are no longer
allowed.

Thanks for any help.
Mike B


--
Disclaimer: Any comments made are personal and do not reflect the thoughts
or policies of this company.