Hi,
Quick question: I have a macro that creates a new worksheet and I was wondering if there was any way in VBA where I can create a Private Sub in that new worksheet automatically when the new sheet is created? It is a change event to call another macro when a certain cell in selected.
Thanks
Ryan
Quick question: I have a macro that creates a new worksheet and I was wondering if there was any way in VBA where I can create a Private Sub in that new worksheet automatically when the new sheet is created? It is a change event to call another macro when a certain cell in selected.
Thanks
Ryan