sangeeta25
Board Regular
- Joined
- Jun 15, 2015
- Messages
- 59
Hi,
I have this macro by which when you click the button, a row is inserted in that spreadsheet, this is the code:
Sub textbox4_click()
Range("G3").EntireRow.Insert Shift:=xlDown
Range("G3") = Range("G4") + 1
End Sub
However what i want to do now is ONLY allow for the button, which has the macro, to insert a row, i.e. i do not want the option of 'insert' when you right click on the spread sheet to insert a row etc.
is this possible?
I have this macro by which when you click the button, a row is inserted in that spreadsheet, this is the code:
Sub textbox4_click()
Range("G3").EntireRow.Insert Shift:=xlDown
Range("G3") = Range("G4") + 1
End Sub
However what i want to do now is ONLY allow for the button, which has the macro, to insert a row, i.e. i do not want the option of 'insert' when you right click on the spread sheet to insert a row etc.
is this possible?
