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

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

Out of town for weekend...Thanks for the info, Myrna.

I've never translated a macro sheet to vba and my main interest is in
modifying the "userform" that is generated. The default button that has the
focus, etc. Is there a general strategy anyone can recommend?

Thanks much,
Geoff

"Myrna Larson" wrote in message
...
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