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