Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
offset command protected
Hi
I am currently using a macro that allows me to insert a row preserving formulas by a doubleclick. Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Cancel = True 'Eliminate Edit status due to doubleclick Target.Offset(1).EntireRow.Insert Target.EntireRow.Copy Target.Offset(1).EntireRow On Error Resume Next Target.Offset(1).EntireRow.SpecialCells(xlConstant s).ClearContents On Error GoTo 0 End Sub Reference: David McRitchie My problem is when i protect my worksheet, this macro fails to operate when it gets to the "Target.EntireRow.Copy Target.Offset(1).EntireRow" part. When protecting i enabled all exceptions and still doesnt work. Is there a way around this. Sorry, I am quite new at all this. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
offset command protected
Maybe you can just add a couple of lines:
Private Sub Worksheet_BeforeDoubleClick(... me.unprotect password:="whatever" 'your existing code me.protect password:="whatever" end sub cjupiter wrote: Hi I am currently using a macro that allows me to insert a row preserving formulas by a doubleclick. Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Cancel = True 'Eliminate Edit status due to doubleclick Target.Offset(1).EntireRow.Insert Target.EntireRow.Copy Target.Offset(1).EntireRow On Error Resume Next Target.Offset(1).EntireRow.SpecialCells(xlConstant s).ClearContents On Error GoTo 0 End Sub Reference: David McRitchie My problem is when i protect my worksheet, this macro fails to operate when it gets to the "Target.EntireRow.Copy Target.Offset(1).EntireRow" part. When protecting i enabled all exceptions and still doesnt work. Is there a way around this. Sorry, I am quite new at all this. Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheets with OFFSET command always ask if I want to SAVE | Excel Worksheet Functions | |||
OFFSET command and linked documents | Excel Worksheet Functions | |||
QUESTION with Match command and OFFSET | Excel Programming | |||
Keyboard command different when protected | Excel Programming | |||
Deleting some cells in a row using command button and offset | Excel Programming |