Macros and Worksheets

[Laf4sens]

Hi,

Like I said before I'm new to this whole MACRO world...

I managed to create 2 buttons on my worksheet that calls 2 macros. I all works fine. So I saved my worksheet.

But now, I want to bring my worksheet to another PC (on my USB key). I copied the XLS file on the other PC and opened the worksheet. When I tried clicking on either button, it told me that it couldn't find the macros !!!!

Is there a way to imbed the macros into the worksheet? Do I have to copy the macros separately from my worksheet?

I want my worksheet to work on ANY PC, what do I have to copy over?

Pleas Help,

Marc

 

[jeffreybrown]

Hi Marc,

Where did you place the macros? Are they part of a module within the worksheet?

If they are then they will transfer with the spreadsheet

http://www.rondebruin.nl/code.htm

 

[Marcelo Branco]

Hi,

1. You have to save your file as macro-enabled, .xlm extension in Excel 2003, not as .xls

2. When opening the file (.xlm) in another PC dont forget to enable macros.

HTH

M.

 

[Laf4sens]

Hi Marcelo,

Thanks for your answer... I'm going to ask a stupid question (first time with Macros):

How do I ENABLE Macros on another PC?

Thanks in advance,

Marc

 

[Michael M]

Hi M
Slight correction

You have to save your file as macro-enabled, .xlm extension in Excel 2003

should be

You have to save your file as macro-enabled, .xlm extension in Excel 2007 or higher

 

[jeffreybrown]

What version of Excel are you running?

 

[Laf4sens]

Hi,

I'm built the worksheet and Macros in Excel 2007. But this will be executed on a PC with Excel 2003...

Thanks,

Marc

 

[jeffreybrown]

Hi Marc,

I don't have 2003 here so I don't remember, but check this out.

http://www.ehow.com/how_5946347_enable-macros-excel-2003.html

If you create macros in 2007 you would save that file as .xlsm, but since you are using it on a 2003 machine then just save it as .xls.

Edit: If you are worried as to whether somebody will enable the macro you could also force the use of macros.

http://www.vbaexpress.com/kb/getarticle.php?kb_id=379

 

[Marcelo Branco]

Hi M
Slight correction

You have to save your file as macro-enabled, .xlm extension in Excel 2003

should be

You have to save your file as macro-enabled, .xlm extension in Excel 2007 or higher

Hi Michael,

Thank you for correcting my post.

M.