Converting XL4 Macro Sheet to VBA

  • Thread starter Thread starter Geoff Martin
  • Start date Start date
G

Geoff Martin

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 said:
No, it can't. This is a manual job in Excel.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA code won't run, even with Macro Security set to Enable All Macors 9
Programming a macro in Excel Office 2007 to create Pivot Table 1
Convert Advanced filter macro to VBA 2
vba code to enable macros 3
Word to Excel: Export comments with text and line number 0
Macro to copy value in field and insert it into filter 2
Converstion of Complex Word VBA macro to Excel Macro 1
view & update (VBA-command button) two sheets concurrently 1

Back
Top