| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable entire row delete on certain sheet
why not just protect the worksheet and unlock those areas you will be making changes everything else will be delete proof
----- Jason wrote: ---- 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 I have got in the habit of just selecting an entire row and right click deleting it. Well on this one I can't do that, but the habit is still there and I have lost data that way. All I want is a way to disable the right click delete on this sheet alone and the best place to stick the code. Any Help??? I thank in advance Sheets("Placements" column(A) column(B) column(C) Column(D)..........Etc Name SS# Code |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disable entire row delete on certain sheet
Good point, but it messes up my other code and that I have already written.
----- chris wrote: ---- why not just protect the worksheet and unlock those areas you will be making changes everything else will be delete proof ----- Jason wrote: ---- 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 I have got in the habit of just selecting an entire row and right click deleting it. Well on this one I can't do that, but the habit is still there and I have lost data that way. All I want is a way to disable the right click delete on this sheet alone and the best place to stick the code. Any Help??? I thank in advance Sheets("Placements" column(A) column(B) column(C) Column(D)..........Etc Name SS# Code |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I disable or delete an Add-In | Excel Discussion (Misc queries) | |||
| Macro to copy values then delete row for entire sheet | New Users to Excel | |||
| Disable the Delete Key | Excel Discussion (Misc queries) | |||
| Disable Delete | Excel Discussion (Misc queries) | |||
| Confirm Delete Message Disable | New Users to Excel | |||
Hybrid Mode
