Major Error
On Thu, 14 Sep 2006 21:30:03 -0700, Steven
wrote:
I have a file that I made a mistake of giving a Function and a Sub the same
name and now when I try to open the file it trys and trys but willnot open
and the system will finally end the task and close Excel. When I restart
Excel it tries to get the file back and it will repair it and I will loose
all the macros. Is there a way to get this file back, like when it is trying
to open is there a way to bypass something and say just open the file.
Thank you for your help.
Steven
In addition to what others have written, this from Excel HELP may be of value:
"To prevent macros from automatically running, hold down SHIFT while you start
Excel.
"Note If you start Excel from the Office Shortcut Bar, click the Microsoft
Excel button on the Office Shortcut Bar first, and then immediately hold down
SHIFT while Excel starts"
--ron
|