I have an excel application in which i want de prevent users from deleting entire rows. Because when they do that the references in other sheets go bad.
So i would want to replace the function of the context menu 'Delete' and 'edit - delete' from delete to clear contents.
how can I do that?
So i would want to replace the function of the context menu 'Delete' and 'edit - delete' from delete to clear contents.
how can I do that?