insert rows in locked worksheet - from Excel 2003 to 2000

  • Thread starter Thread starter Venus
  • Start date Start date
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!
 
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
 
Back
Top