export as vba macro
In the VBIDE you can export the code module (FileExport). This can then be
imported into any other workbook.
But if you mean code attached to the worksheet, this won't work as importing
fails, but you can move the code to a module and use simple single calls to
the macros from the worksheets.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"sali" wrote in message
...
is there some tool to export excel worksheet as vba code?
i mean, to create equal macro, which would, when run, recreate original
worksheet
|