Row Inserts - Disabling Protection.

  • Thread starter Thread starter Mike Bennett
  • Start date Start date
M

Mike Bennett

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Allow Insert Rows in a protected worksheet 2
how do I insert row keeping formulas from previous row? 1
Can't use protection options 1
password protect allowances 1
ProtectSheet Options are un-checking after macro 9
Worksheet protection, going beyond inserting rows 6
Excel Allowing users to add rows in protected excel table 2
security - protecting a worksheet 2

Back
Top