BeforeDelete key event???
Posted by Beginner Bob on February 22, 2001 2:57 PM
Back for some more help. I have a workbook where I add sheets with a custom built menu. Info is added to the worksheets via userform input, auto sorted alphabetically, then subtotalled with a macro. I would like to have a msgbox pop-up if the user tries to delete anything in the range "A4:H65536" on any sheet, asking the user if he/she would like the whole row deleted or nothing at all (since the subtotal function coupled with the autosort macro screws everything up.) I know I could protect the sheet and put a button in my menu for delete row, but I would like to not have to protect the sheet. I think I would need to put this in the workbook code, since sheets are added at later dates. Can someone help me with this? Thanks in advance.