By guest contributor: Yoav Ezer
NOTE: This post provides an example spreadsheet: accelerating-excel.xlsm. Due to concern for your system's security, macro enabled...
This post has been superseded. Please see: https://itknowledgeexchange.techtarget.com/beyond-excel/excel-data-entry-protection-solution/
Last post we discussed the theory behind the WorkSheet_Change event code below. This code must be in the WorkSheet class as it only responds to events for the worksheet that contains it. Here is the code:2 Comments RSS Feed Email a friend
When the user changes something and
When they want to post entries to the database (aka add, change or delete data).