Hi,

I made a worksheet with some macros (in Excel 97) that
properly works on my PC (no matter the excel version I
use to open it), but when I send it by mail to a
customer, he can open it, but macros doesn't work on his
PC.

Before sending the file, I protected the macros with a
password.
He has a Excel 2000 installed, with a LOW level of
protection.
The message he got is something like: "The macro XXX does
not exist".
It seems like macros disappered on his worksheet, since
when he tries to open the Visual Basic Editor the project
appears empty.

How to explain this behaviour?
Are there some setting I can change in Excel or this is
depending on something "external" (ex. a firewall that
deletes all macros..)

thank you,

Matteo

It's possible the macros you are executing have been recorded to your
personal macro workbook. Macro code, forms etc. are completely self
contained within the Excel file so there should be no obvious reason why the
macros have disappeared. Getting unexpected results from the macros on
another machine is a more common problem.



--

Regards,


Bill Lunney
www.billlunney.com

"Matteo" wrote in message
...
Hi,

I made a worksheet with some macros (in Excel 97) that
properly works on my PC (no matter the excel version I
use to open it), but when I send it by mail to a
customer, he can open it, but macros doesn't work on his
PC.

Before sending the file, I protected the macros with a
password.
He has a Excel 2000 installed, with a LOW level of
protection.
The message he got is something like: "The macro XXX does
not exist".
It seems like macros disappered on his worksheet, since
when he tries to open the Visual Basic Editor the project
appears empty.

How to explain this behaviour?
Are there some setting I can change in Excel or this is
depending on something "external" (ex. a firewall that
deletes all macros..)

thank you,

Matteo

I think I'd try resending the workbook.

Maybe even zip it before sending. (www.winzip.com has a evaluation period)


Matteo wrote:

Hi,

I made a worksheet with some macros (in Excel 97) that
properly works on my PC (no matter the excel version I
use to open it), but when I send it by mail to a
customer, he can open it, but macros doesn't work on his
PC.

Before sending the file, I protected the macros with a
password.
He has a Excel 2000 installed, with a LOW level of
protection.
The message he got is something like: "The macro XXX does
not exist".
It seems like macros disappered on his worksheet, since
when he tries to open the Visual Basic Editor the project
appears empty.

How to explain this behaviour?
Are there some setting I can change in Excel or this is
depending on something "external" (ex. a firewall that
deletes all macros..)

thank you,

Matteo

--

Dave Peterson

Hi Dave,

Maybe even zip it before sending. (www.winzip.com has a evaluation period)

A free program (free for everybody) to zip and unzip files can be found in
UltimateZip - the archiver for the future
http://www.ultimatezip.com
http://www.ultimatezip.com/download.htm -- directly to download page

UltimateZip - Download, reportedly better than WinZip. UltimateZip is free
unlike Winzip. Can unzip to new folder same name, same folder, or
anywhere else. Can look at files without permanently unzipping.
Right-click options.

Being able to right click on a zip file makes it very easy to use. I tried
WinZip a long time ago and hated it because the GUI interface
took a lot more effort than using PKZIP that I had been used to,
and because I would have to pay for it on my own system.

Add to Archives
Add to "filename".zip
Zip and E-mail "filename".zip

Extract to...
Extract to here
Extract to folder
Create Self-Extractor (.exe)
E-mail ...zip
---
HTH, (see my webnofee.htm page)
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Dave Peterson" wrote in message ...
I think I'd try resending the workbook.

Maybe even zip it before sending. (www.winzip.com has a evaluation period)


Matteo wrote:
[clipped]

Hi,

I sent the entire worksheet to the customer via another email address,
which is not passing thru the same mail server.
The macros are now working properly!

Probably it's the mail server that deletes all the macros in a file
(even if I change the extension .xls)

Thank you for your suggestions,

Matteo

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!