worksheet_change from Module?

[Siegfrid15]

Hi,
I use excel as a macro template to do things in another excel (start with certain shortcut and it is running, no problem).
The macros are saven in Module in the template excel.
I would like to use worksheet_change also in the new excel, with data in Sheet1.
How can I do this starting from the "template excel"? Is it possible?

E.g. I place this code as test in my "template excel", run the routine and can use the same worksheet_change in the new excel.

Many thanks for help

Public Sub worksheet_change(ByVal target As Range) 
 
If target = Cells(1, 1) Then 
Cells(1, 2) = "test" 
End If 
 
End Sub  

[mehmetcik]

The way I usually do that sort of thing is to have the macro in a template sheet in my original workbook.

I can then copy the sheet to the new workbook complete with the macro.

Can that not work for you?

If not I will try and remember how to create a macro using vba for you.

Please Login or Register  to view this content.

1. You may need to Enable Applications Extensibility 5.3

select the tools menu and "References"

Then find "Microsoft Visual Basic for Applications Extensibility 5.3 library" and check it.
enter image description here

2. You may need to modify the Trust Centre settings.

Click Application Options.
Click the Trust Center tab, and then click
Trust Center Settings.
Click the Macro Settings tab, click to select the Trust access to the VBA project object model check box, and then click OK.
Click OK.

[Siegfrid15]

OK, I didn't see your next post. Thanks, I will check if this could work for me. Thank you very much

xxxxxxxxxxxxxxxxxxxxxxxxxxxx
I don't think it would, unless I don't understand competely what you're saying. The data in sheet1 = template will be different then data in sheet1 = another workbook, the columns will be the same,
but not the data.
It is possible to copy the macro code only, like it is done into excel, but only within macros? maybe something with VBAProject.xxxxx?
I don't know really.
Thanks for help anyway!