Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
line delete interception
Hi from Paris (France)
I want to save a specified data (cell in colonne A:A) of a line to be deleted, before suppression. How can intercept the line delete event ? Thanks by anticipation, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
line delete interception
Hi,
The row delete fires the 'Worksheet_Change' event ... but so do lots of things. Regards, Chris. -- Chris Marlow MCSD.NET, Microsoft Office XP Master " wrote: Hi from Paris (France) I want to save a specified data (cell in colonne A:A) of a line to be deleted, before suppression. How can intercept the line delete event ? Thanks by anticipation, |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
line delete interception
Thanks Chris for the suggestion,
Is there any way to detect deleted line , previously its deletion ? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
line delete interception
Hi,
Unfortunately the Target range returned in Worksheet_Change refers to the new row (i.e. the one that was below what you have deleted). I looked at something like; If Target.Rows.Count = 1 And Target.Columns.Count = 256 Then Application.Undo 'Save the details down here Application.Repeat End If But I don't think there is the sophistication in the worksheet events to capture this. I've looked at Application.Undo ... but does not seem to meet the need. I think you would need to set up your own 'delete row' macro & have users use that macro. Regards, Chris. -- Chris Marlow MCSD.NET, Microsoft Office XP Master " wrote: Thanks Chris for the suggestion, Is there any way to detect deleted line , previously its deletion ? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
line delete interception
Unfortunately, there is no way to detect when a user deletes a
row. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com wrote in message oups.com... Hi from Paris (France) I want to save a specified data (cell in colonne A:A) of a line to be deleted, before suppression. How can intercept the line delete event ? Thanks by anticipation, |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
line delete interception
Thanks for your help, Chris and Chip. May be in the next Excel version ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Challenge - Excel Line Feed Character CHR(10) - How to Delete and keep the text formatting without going ro single line in a cell ? | Excel Worksheet Functions | |||
Delete all but first line | Excel Discussion (Misc queries) | |||
Delete every other line | Excel Programming | |||
Delete every other line | Excel Programming | |||
how to delete to the end of line | Excel Programming |