Please help! Why do I lose all macros when I close and restart workbook?

I always get a message VBA modules lost. All the macros I
recorded dissappears.

Please give the exact wording and punctuation of the message.
In text, of course.

Also it is not a good idea to include information in the header that is
not included in the text body, because the header is not reread as
part of the problem.

Exactly when do you get the message it certainly would not be
at both close and at open.

In order to use macros your security setting must be set to
medium as opposed to high.
tools, macros, security
---
HTH,
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

"tom" wrote in message ...
I always get a message VBA modules lost. All the macros I
recorded dissappears.

David,

I tried setting the security level, but no help. This
error occurs evertime I record a macro. After saving the
spreadsheet, I would open it again.

Since I am using the chinese version of office, I will
translate as best as I could what happens.

Dialog box: Module lost
I have to hit ok or help.

Spreadsheet loads up and another dialogue box comes up:

There is an error in XXXX file. But Microsoft excel is
able to fix the following problem and open up the file.
Please save the file to keep the changes.

Can't find VB Project.

Click on link to find log: c:docume~1\thomas\locals~1
\temp\repair03076 08.txt

The file there basically says I lost the VB project.

Thanks.




-----Original Message-----
Please give the exact wording and punctuation of the
message.
In text, of course.

Also it is not a good idea to include information in the
header that is
not included in the text body, because the header is
not reread as
part of the problem.

Exactly when do you get the message it certainly would
not be
at both close and at open.

In order to use macros your security setting must be set
to
medium as opposed to high.
tools, macros, security
---
HTH,
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

"tom" wrote in
message ...
I always get a message VBA modules lost. All the
macros I
recorded dissappears.


.

Too bad the message error has to be translated from Chinese.

----------
I presume this is not the error. I forced this by changing the macro assigned
to a tool bar button.

'persvvonal.xls' could not be found. Check the spelling of the file name, and verify that the file location is correct.

If you are trying to open the file from your list of most recently used files on the File menu, make sure that the file
has not been renamed, moved, or deleted. [OK]
-------------

Since you can find the file, perhaps you have too many macros in
a module. Postings by Rob Bovey and Charles Williams give an approximate
limit of about 64KB that can be exceeded. You can estimate the size
of a module by exporting it. But for efficiency you code should be
in several modules with things that may be used together in the same
module. The more modules you bring in the more more memory you are going
to use as you activate more modules.

Make sure that the code you are adding is to a new module.
--
---
HTH,
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

wrote in message ...
David,

I tried setting the security level, but no help. This
error occurs evertime I record a macro. After saving the
spreadsheet, I would open it again.

Since I am using the chinese version of office, I will
translate as best as I could what happens.

Dialog box: Module lost
I have to hit ok or help.

Spreadsheet loads up and another dialogue box comes up:

There is an error in XXXX file. But Microsoft excel is
able to fix the following problem and open up the file.
Please save the file to keep the changes.

Can't find VB Project.

Click on link to find log: c:docume~1\thomas\locals~1
\temp\repair03076 08.txt

The file there basically says I lost the VB project.

Thanks.




-----Original Message-----
Please give the exact wording and punctuation of the
message.
In text, of course.

Also it is not a good idea to include information in the
header that is
not included in the text body, because the header is
not reread as
part of the problem.

Exactly when do you get the message it certainly would
not be
at both close and at open.

In order to use macros your security setting must be set
to
medium as opposed to high.
tools, macros, security
---
HTH,
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

"tom" wrote in
message ...
I always get a message VBA modules lost. All the
macros I
recorded dissappears.


.