| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2000 Lists - Insert Row in Protected worksheet | Excel Discussion (Misc queries) | |||
| worksheet in excel 2000 different than 2003 | Excel Discussion (Misc queries) | |||
| How can I insert and delete rows within a locked cell range column | Excel Worksheet Functions | |||
| Excel 2003 says worksheet is locked for editing | Excel Discussion (Misc queries) | |||
| unlocked cells in excel 2000 now locked when opened in 2003 why? | Excel Discussion (Misc queries) | |||
Linear Mode
