jenlynn8402
New Member
- Joined
- Mar 28, 2011
- Messages
- 1
Using Excel 2007 with a customized ribbon and trigger events.
I have a workbook that was given to me that serves as a database for content. The workbook is edited by our editorial staff frequently. In the workbook each row consists of multiple data columns and an ID column. I lock the ID column. My problem is that the editors need to be able to delete rows. When they select the row and delete, it tries to delete the locked cell and throws an error ("The cell or chart that you are trying to change is protected and therefor read-only.")
Is there a way to capture an event before this error is shown? I have the
Application_SheetChange already coded but the Excel error is thrown before it hits this event. Any ideas?
I have a workbook that was given to me that serves as a database for content. The workbook is edited by our editorial staff frequently. In the workbook each row consists of multiple data columns and an ID column. I lock the ID column. My problem is that the editors need to be able to delete rows. When they select the row and delete, it tries to delete the locked cell and throws an error ("The cell or chart that you are trying to change is protected and therefor read-only.")
Is there a way to capture an event before this error is shown? I have the
Application_SheetChange already coded but the Excel error is thrown before it hits this event. Any ideas?
