proper copying 1 macro to other similar excel file - so it'll work

[netanel99]

Hello , I'm trying to use the macro in U1.xlsm in U2.xlsm but I'm a beginner , and can't figure out how to do it.
what I'm trying to do is to copy the working macro from U1 to U2, (without deleting sheets) .
I'm curious why I wasn't able to do it, will like to learn how to . thanks

[tehneXus]

Like here?: U2.xlsm

What I did:
1. Enter Design Mode in Developer Tab and copy/paste the button into the U2 workbook.
2. Create a Module in U2 and copy the code from Modul1 U1 into it
3. Copy the code from the worksheet module in U1 to the worksheet module where the button is
4. Change the target range for the text form inpputbox From E3 to E2
5. Remove the Named Range 'Receipe name"

[netanel99]

thanks again tehneXus, even though I don't know exacly how this macro works- it's just works great.

Just thinking on a future scenerio - I want to add a lot of macros, vb codes, formulas in the template sheet so I'll add as the time goes, Can I do it without worries for errors ? (specialy the error of : "the cell name "X" is already exist - do you want to use it independently?...") ?
and is it have any meanings to try to keep the Named Range 'Receipename" so it'll work anyway , for now - If that named range won't removed - it'll show this error every time I'll add new one :"recipename already exist" - why it ask for this name approval and other names not (I'm worry that I'll accedently do something and it'll start to ask me for a lot lot more names approval

[tehneXus]

Hi,

honestly I am not used to named ranges as I rarely use them.
I'd just start working on the template, testing functionality carefully and in case there will be an error, investigate.

[netanel99]

I read you. thank you for your help. This is a great feature, will use it anywhere I can in excel. thanks!