As per the title, I need to run several commands before the user can delete the selected cell. Let me explain the setup. I have built an excel workbook which acts like a database. My desire would be to use only forms, however the customer wants to be able to modify entries on an excel spreadsheet. As I know some of you are thinking, big problems.
The user is able to attach one file to each new entry, which is accomplished through use of forms(both creating a new entry and uploading the file). The file is stored in a network folder. A hyperlink is then created in a column on the main data storage spreadsheet which loads the file upon being selected.
Here's my problem. Since the user can see and modify items in spreadhseet format, I need to be able to proccess certain commands before the user deletes anything on the sheet. There doesn't appear to be any worksheet event which runs commands before something is deleted.
To clarify, the user can modify individual entries which begin on the fifth row. The creates the potential for the user to delete a row of data, which in turn deletes the hyperlink to the uploaded file. There is no problem with the user deleting the row, the problem is that I need to trace which attached file is with the deleted entry so it can also be deleted.
If this isn't very clear let me know.
TIA,
BD
The user is able to attach one file to each new entry, which is accomplished through use of forms(both creating a new entry and uploading the file). The file is stored in a network folder. A hyperlink is then created in a column on the main data storage spreadsheet which loads the file upon being selected.
Here's my problem. Since the user can see and modify items in spreadhseet format, I need to be able to proccess certain commands before the user deletes anything on the sheet. There doesn't appear to be any worksheet event which runs commands before something is deleted.
To clarify, the user can modify individual entries which begin on the fifth row. The creates the potential for the user to delete a row of data, which in turn deletes the hyperlink to the uploaded file. There is no problem with the user deleting the row, the problem is that I need to trace which attached file is with the deleted entry so it can also be deleted.
If this isn't very clear let me know.
TIA,
BD