LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 39
Default Disable entire row delete on certain sheet

Sorry this took so long, but it worked and I thank you very much. Sorry about the long delay in responding

----- Tim Zych wrote: ----

I think this is all of them

Behind the applicable sheet
'-------------------------------
Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel A
Boolean
Application.CommandBars.FindControl(, 293).Enabled = Fals
End Su

Private Sub Worksheet_Deactivate(
Application.CommandBars.FindControl(, 293).Enabled = Tru
End Su
'-------------------------------

Behind ThisWorkbook
'-------------------------------
Private Sub Workbook_BeforeClose(Cancel As Boolean
Application.CommandBars.FindControl(, 293).Enabled = Tru
End Su

Private Sub Workbook_Deactivate(
Application.CommandBars.FindControl(, 293).Enabled = Tru
End Su
'-------------------------------





"Jason" wrote in messag
..
I have a sheet with names and codes of placements for work. From column(D

onward is other information. Well from the way my other sheets are set up
have got in the habit of just selecting an entire row and right clic
deleting it. Well on this one I can't do that, but the habit is still ther
and I have lost data that way. All I want is a way to disable the righ
click delete on this sheet alone and the best place to stick the code. An
Help??? I thank in advance
Sheets("Placements"
column(A) column(B) column(C) Column(D)..........Etc

Name SS# Cod






 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I disable or delete an Add-In dhstein Excel Discussion (Misc queries) 2 April 13th 09 02:10 AM
Macro to copy values then delete row for entire sheet Pyrotoy New Users to Excel 18 December 9th 08 12:43 AM
Disable the Delete Key CarolK1968 Excel Discussion (Misc queries) 3 January 30th 08 07:20 PM
Disable Delete Kevin Excel Discussion (Misc queries) 0 July 29th 07 02:58 PM
Confirm Delete Message Disable RiosPapa New Users to Excel 2 October 7th 05 09:02 PM


All times are GMT +1. The time now is 05:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"