Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bypassing startup macros
Paul,
no the exception still occurs, Is there a command line I can use to open it up without using the macros? Sion "Paul B" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bypassing startup macros
set your macro security protection to high and you should be prompted to
disable macros when you open the workbook. I am not aware of a command line switch that disables macros. -- Regards, Tom Ogilvy "Sion Smith" wrote in message ... Paul, no the exception still occurs, Is there a command line I can use to open it up without using the macros? Sion "Paul B" wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bypassing startup macros
I posted a URL in response to your question concerning that.
http://www.openoffice.org -- Regards, Tom Ogilvy "Sion Smith" wrote in message ... Hi Tom, I've tried to disable the macros but it has no effect!! Thomas has suggested using Openoffice but I'm not familiar with it and don't know how to acquire it Thanks anyway Sion "Tom Ogilvy" wrote: set your macro security protection to high and you should be prompted to disable macros when you open the workbook. I am not aware of a command line switch that disables macros. -- Regards, Tom Ogilvy "Sion Smith" wrote in message ... Paul, no the exception still occurs, Is there a command line I can use to open it up without using the macros? Sion "Paul B" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enable Macros question at Startup | Excel Discussion (Misc queries) | |||
Bypassing ENABLE/DISABLE MACROS message | Excel Discussion (Misc queries) | |||
Excel startup macros - visibility of... | Excel Programming | |||
Bypassing password | Excel Programming | |||
Bypassing Protections | Excel Programming |