Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Preventing partial row deletions to avoid row data shifts
Anyone have any ideas on presenting a user with a msgbox or form if a
single cell or range that is not an entire row is deleted and cell shifted either up or left? I've seen the question posed a few times in google for all excel groups, but have not found any answers. Microsoft's site didn't yield anything either. I have some code that checks the integrity of the last row of populated cells to see if the row number is the same and prevents a save of the application if the row numbers are skewed, but I'd rather stop any data shifts from happening with a message to the user that deleting small portions of a row is not allowed and then cancel their action if that is possible. I've toyed with the idea of intercepting the built in dialog asking whether to shift the cell up or left, (xlDialogDataDelete??), but haven't been able to find much on that. Any help would be appreciated. Dave Freidel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set up a spsht to allow adding data only - no deletions | Excel Discussion (Misc queries) | |||
Sorting data on a worksheet for different users (shifts) | Excel Discussion (Misc queries) | |||
Preventing Data Import | Excel Discussion (Misc queries) | |||
Preventing duplicate data | Excel Discussion (Misc queries) | |||
Data Form Deletions | Excel Discussion (Misc queries) |