I know that Excel doesn't provide an event for delete. So how can we detect whether user delete some rows or cells and know which ranges that user just delete (if possible, also provide a way to cancel that?
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
The change event won't necessarily be triggered by that. And when it is it's already too late.
If any of the events may help you it would be the SelectChange event. You could prevent a user from selecting those rows (to delete, copy, paste, whatever).
But I think you'd be better of by protecting the sheet as GoBanana suggested...
Paulo
This is a problem I came across recently also. I wanted to know if the shapes of certain ranges had changed. I didn't actually get round to implementing it, but here is what I thought of:-
You can store each of your particular ranges in, say, an array. These are just pointers to ranges, so they get automatically updated. You can then use the WorksheetChange event, and check to see whether these ranges have changed shape.
Of course, that doesn't stop the user deleting the range...
How about this scenario:
* You protect the sheet.
* Whenever someone wants to delete something selects it and then presses a button on a toolbar (or a shortcut key combination that you assign to it such as Ctrl+X, for instance)
* A dialog box then pops up to allow the user to enter the information you want.
* The sheet is then unprotected, the cells deleted and the sheets gets reprotected again.
However with the sheet selected you'll loose the ability to change the cells values, widths, formating, etc. You won't loose the ability to insert new values if you do it right and use the change event to only lock the cells with values.
What do you think about this acenario?
Paulo
Business Accounts
Answer for Membership
by: GoBananaPosted on 2003-04-01 at 13:34:29ID: 8248933
And why, may I ask, do you want to do that? Why not simply lock cells that should not be deleted?
There is a change event. May that perhaps be of interest?Hard for me tell since I do not know your intentions with your excel model.
GoBanana