Excel Macro to another computer---How?

[qureshi]

Hi,
I started off by recording a excel macro on my computer and ended with a lot of code.The macro was saved in the Personal.xls sheet. In order to give a better picture, the personal.xls workbook contains a user form, couple of Sub routines and the macro itself.
I have to transfer this whole "thing" to another network computer. I thought it would be done by copying my personal.xls workbook to the other computer. So I did that. The other computer displays the userform but is unable to run the code in the macro. The code is something like this:

After the user makes his selection from the userform
CommandButton-Click event
outputfile=textbox2.value
macro2
macro3
end
end sub

Any tips/help will be appreciated.
Thanks
Qureshi

 

[dan1967]

What you did should have worked. Open the application in the other computer. Go to the Tools->Macros->Security option. Make sure the setting is on Medium. This setting prompts you when a macro is attached to an Excel file (Disable Macro ... Enable Macro ... Don't Open File). This works in Excel 2k and later.

Dan.