T
tom
I always get a message VBA modules lost. All the macros I
recorded dissappears.
recorded dissappears.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Please help! Why do I lose all macros when I close and restart workbook?
D
David McRitchie
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
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
G
Guest
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.
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.
message news:[email protected]...-----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
"tom" <[email protected]> wrote in
D
David McRitchie
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.
----------
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.