public sub worksheet_change ever possible?

J

Jiheon.Yang

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
 
V

Vergel Adriano

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Worksheet_Change Recursion ARGHH! 6
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Worksheet_Change event very slow 5
Newbie question regarding using Sub Worksheet_change() 2
Can an add-in macro update a worksheets Worksheet_Change function? 1
Hide rows of one sheet based on values in another sheet? 3
How to temp disable Worksheet_Change Event while code in same completes? 4
Defining public/global variables in more than one place 1

Top