Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all,
Maybe it's a kinda stupid question...but Im frustrated to get this sorted! Basically I created a workbook with sheets protected, which also involves some macros behind. It works perfectly in Excel 2003, but it fires run-time error 1004: You cannot sue this command on a protected sheet. To unprotect the sheet, use the Unprotect Sheet command...(rest omitted) In debugging, the following line was focused: Selection.Insert Shift :=xlDown Apparently such an insertion attempt is not allowed(?). I have unprotected the current sheet far at the beginning using: masterworkbook.Sheets("Shipper").Unprotect Password:="MyPIN" So can anyone tell why this does not work in Excel 2000(it does for Excel 2003)? How can the insertion be done legitimately in Excel 2000 then? Thanks in advance to any response!! Regards Frank |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
xls file works fine in Excel 2000 and 2007 but crashes on opening in 2003 | Excel Discussion (Misc queries) | |||
#VALUE! error: vlookup works in Excel 2000 but not 2003 | Excel Discussion (Misc queries) | |||
Simple Macro, works in Excel 2002, 2003 but won't work in 2000 | Excel Programming | |||
VBA Code works in Excel 2003 but won't work in Excel 2000 | Excel Programming | |||
VBA Code works in Excel 2003 but won't work in Excel 2000 | Excel Programming |