Bypassing startup macros
Sion, why not just disable macros when you open the workbook? To disable
start up macros hold the shift key when you open the workbook.
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **
"Sion Smith" wrote in message
...
Hi there,
I've created an Excel sheet with lots of VBA code behind it. Unfortunately
Excel is now throwing an illegal exception preventing me from opening the
file - apparently it's something to do with the requirement for Office 97
SR2
patch. I can't resolve this issue as the group IT function can't (or
won't)
apply the patch!
How can I retrieve the VBA modules so that I don't have to recreate the
code
within them when I apply them to the previous backup versions I have of
the
file(it could take up to a week to recreate it if I can't retrieve it).
I'm
thinking along the lines of shortcut keys available in Access to bypass
the
startup macro etc....
Thanks in advance
Sion Smith
|