I have the following probelm.
I have a workbook with a number of modules(vba code).
I save it to 2 different partitions (just in case).
It happens regularly that I get an error message that option is not
available and then the sheet opens, formatting has dissapeard and all
the modules are gone.
I do not get a virus message or anything else when saving, and my
protection is set low so I don't get the prompt if I want the macro's
to run.
It happens more often on one of the HDD partitions than the other.
Any Ideas? Suggestions? Coukd it be a Bad Disk (spank it!) or something
known?
Thanks, Hans (hhalle)--
hhalle
Male
------------------------------------------------------------------------
hhalle's Profile: www.excelforum.com/member.php...oamp;userid=20829
View this thread: www.excelforum.com/showthread...hreadid=507120It sounds to me like the workbook is corrupted.
Lots of people have praised OpenOffice.org for saving their data and code.
www.openoffice.org, a 60-65 meg download or a CD
There are commercial recovery services. I've never used it, but you might want
to check into:
www.officerecovery.com
And sometimes newer versions of excel can open files that older versions can't.
(And sometimes just different versions may work, too!)
hhalle wrote:
gt;
gt; I have the following probelm.
gt; I have a workbook with a number of modules(vba code).
gt; I save it to 2 different partitions (just in case).
gt; It happens regularly that I get an error message that option is not
gt; available and then the sheet opens, formatting has dissapeard and all
gt; the modules are gone.
gt; I do not get a virus message or anything else when saving, and my
gt; protection is set low so I don't get the prompt if I want the macro's
gt; to run.
gt; It happens more often on one of the HDD partitions than the other.
gt;
gt; Any Ideas? Suggestions? Coukd it be a Bad Disk (spank it!) or something
gt; known?
gt;
gt; Thanks, Hans (hhalle)
gt;
gt;
gt; --
gt; hhalle
gt;
gt; Male
gt; ------------------------------------------------------------------------
gt; hhalle's Profile: www.excelforum.com/member.php...oamp;userid=20829
gt; View this thread: www.excelforum.com/showthread...hreadid=507120
--
Dave Peterson
- May 27 Tue 2008 20:44
VBA code is being deletd from WorkBook
close
全站熱搜
留言列表
發表留言
留言列表

