Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Delete Row
I got all of my other problems fixed. Here is my newest question, sorry if
you are getting tired of them... Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean) Application.CommandBars.FindControl(, 293).Enabled = False End Sub Private Sub Worksheet_Deactivate() Application.CommandBars.FindControl(, 293).Enabled = True End Sub This disables the delete row for the active sheet, which is perfect. However when i copy that sheet, i need to enable the delete row. This can be done anyway possible, i just dont know how to write the code for it. Please advise... -- Message posted via http://www.officekb.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I disable or delete an Add-In | Excel Discussion (Misc queries) | |||
Disable the Delete Key | Excel Discussion (Misc queries) | |||
Disable Delete | Excel Discussion (Misc queries) | |||
Confirm Delete Message Disable | New Users to Excel | |||
How to disable delete operation | Excel Programming |