macro

[ditzafar]

When I recording the macro I can use it in others workbooks, but when
I'm typing the code in v.b I can use the macro only on the specific
workbook. I have no idea what can be the problem. thanks.

 

[Guest]

Where are you putting the code? Try inserting a module and then typing the
code (or copying/moving it) there. Then you should be able to bring it up
using Alt-F8.

 

[Gord Dibben]

ditz

I'm guessing that when you record a macro you are recording to your "personal
macro workbook" which is Personal.xls and is the storage file for global
macros.

When you go into the VBE you may be typing the code into the workbook that is
open.

Type your code into the Personal.xls module(s)

When in the VBEditor look for Personal.xls and expand it to see the module(s)
to edit or type new code into.

Also make sure any coding lines refer to ActiveWorkbook and ActiveSheet and
not hard-coded to a specific book or sheet.


Gord Dibben Excel MVP