public sub worksheet_change ever possible?
I don't mean it in the syntax way but conceptually can
worksheet_change be in public scope? Instead of copying and pasting the same code for each sheet vba coding, I was wondering if there's way to put worksheet_change in thisworkbook and call the function from each sheet. TIA, Daniel |
public sub worksheet_change ever possible?
Maybe you could use the Workbook_sheetchange() event.
wrote: I don't mean it in the syntax way but conceptually can worksheet_change be in public scope? Instead of copying and pasting the same code for each sheet vba coding, I was wondering if there's way to put worksheet_change in thisworkbook and call the function from each sheet. TIA, Daniel -- Dave Peterson |
public sub worksheet_change ever possible?
Jiheon,
The workbook_sheetchange() event fires after the worksheet_change() event. So you can probably tweak your worksheet_change code and make it work in the workbook_sheetchange event... -- Hope that helps. Vergel Adriano " wrote: I don't mean it in the syntax way but conceptually can worksheet_change be in public scope? Instead of copying and pasting the same code for each sheet vba coding, I was wondering if there's way to put worksheet_change in thisworkbook and call the function from each sheet. TIA, Daniel |
All times are GMT +1. The time now is 11:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com