PC Review


Reply
Thread Tools Rate Thread

Disable Delete Row

 
 
brownti via OfficeKB.com
Guest
Posts: n/a
 
      1st Mar 2007
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

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I disable or delete an Add-In dhstein Microsoft Excel Misc 2 13th Apr 2009 02:10 AM
Disable the Delete Key CarolK1968 Microsoft Excel Misc 3 30th Jan 2008 07:20 PM
Disable Delete Kevin Microsoft Excel Misc 0 29th Jul 2007 02:58 PM
Disable Delete key =?Utf-8?B?cm1jb21wdXRl?= Microsoft Access Form Coding 9 30th Sep 2006 01:14 PM
How to disable Delete Cookies/Delete Files button =?Utf-8?B?cGFyZGFsNTE=?= Windows XP Security 1 11th Jan 2005 07:12 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:52 AM.