View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
 
Posts: 2,824
Default Excel XP Macro Loading Problem

I've protected lots of worksheets and lots of workbooks and never had this
problem--so I don't think it's directly related to the these.

But a butterfly flaps its wings in Ecuador and we have rain 3 days later (so who
knows anything for sure <vbg).



"%P*Rr&^" wrote:

So this is not an unknown problem? Does anyone know if it could be related
to locking the spreadsheet. 'Cause that's the last thing I did and I may
not have tested the macro's before saving and shutting down Excel. I'll
check out OpenOffice.

"Dave Peterson" wrote in message
...
a few people have reported success using OpenOffice to
open their workbooks and recover both the worksheet stuff and macro stuff.

(http://www.openoffice.org, a 60-65 meg download or a CD)

"%P*Rr&^" wrote:

Yup!

"Bill Manville" wrote in message
...
%P*Rr&^ wrote:
Help! I wrote a vba macro for Excel XP, ran it (and it ran without
problems), saved the spreadsheet, exited Excel and later reloaded

the
spreadsheet - but now while loading the spreadsheet, Excel crashes!


You;ve tried holiding down the shift key while opening, to prevent
Auto_Open macros from running?


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup


--

Dave Peterson


--

Dave Peterson