insert rows in locked worksheet - from Excel 2003 to 2000

V

Venus

Hi, I have locked a worksheet in Excel 2003, but it gives people the option
to insert rows. Now I have someone who's using Excel 2000 who says that she
can't insert rows, nor can she copy & paste the information (others have been
able to do it, whether they're using 2003 or 2007). Can she actually insert
the rows and do copy & paste while using 2000? If so, how?

Thanks in advance!
 
G

Gord Dibben

I don't think that option was available in 2000 version.

You would use VBA macro to unprotect, do the job then re-protect.

ActiveSheet.Unprotect Password:="justme"
do the deed
ActiveSheet.Protect Password:="justme"


Gord Dibben MS Excel MVP
 

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

Excel Unable to insert cut rows into Excel online anymore? 0
Excel 2007 - Cannot Delete or Insert Rows 1
Copying locked cells 6
Allow Insert Rows in a protected worksheet 2
insert row and copy formula in protected worksheet 4
Allowing row deletion in worksheet with locked cells 2
Excel 2000 Lists - Insert Row in Protected worksheet 1
How to paste rows in 2007 without overwriting data? 4

Top