No, it can't. This is a manual job in Excel.

On Thu, 25 Nov 2004 22:39:08 -0500, "Geoff Martin" wrote:

I have an Excel Template that has an Excel 4 Macro Sheet in it. I understand
that MS Word can convert WordBasic Macros to VBA. Can Excel similarly
convert a macro sheet into VBA automatically? I'm sure the resulting code
might need some tweaking, but it would be better than starting from scratch.

Thanks much,
Geoff