insert rows in locked worksheet - from Excel 2003 to 2000
 

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!

insert rows in locked worksheet - from Excel 2003 to 2000
 

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

On Wed, 1 Apr 2009 08:27:01 -0700, Venus
wrote:

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!