|Please note that since we can't see your workbook from where we are sitting, we are making some assumptions about what is going on. Hopefully the following infomation will be helpful.|
First let's start with this: "When I copy a file to another workbook "
You can't copy a file to a workbook. A workbook is a file. You can copy a Sheet from one workbook to another workbook, so I'll assume that that is what you meant.
While paulsep is correct in that it appears that you are missing some "macros", let's be more specific.
It looks like there are User Defined Functions (UDF) in the original workbook. UDF's are pieces of VBA code that allow users to create and use functions that do things other than the built in functions that Excel provides.
A UDF is written and stored in a Standard Module in the Visual Basic Editor. Once it is stored, it becomes available for use as a cell based function, meaning that it essentially acts like any other Excel function.
A "macro" is usually considered a piece of VBA code that is run either manually by a user or automatically via a Event. A macro is not entered into a cell like a UDF is. Even though both macros and UDF's are written with VBA code, they are very diffferent.
As paulsep said, show the Developer tab as explained here:
In the original workbook, go into the VBA editor, open the module containing the code and copy the code. In the VBA Editor of the new workbook, click Insert...Module. Paste the code into the pane that opens. Save the workbook.
The UDF's should now work in the new workbook.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
message edited by DerbyDad03