NEED HELP!!! Getting an ulser from this one.

thewesties · Apr 23rd, 2002, 10:50 AM

I have been developing a spreadsheet project for the past two months. I have made backups of the original workbook regularly. However, over the past 2 days I have made major changes and developments. Now, I try to open the file, it goes through the motions of opening it, gets to about 75 percent then quits. Is there a way to open the file in safe mode (or similar) so I may view the VBA to make sure there is no bad scripting.
The last time I accessed it was about an hour and a half ago (with no problems).
I have tried opening with other versions of Excel...no good.
I have linked to the workbook. the links work, so I know the data is there.
I have rebooted.
I have lost half of my hair....
PLEASE HELP!!!!

Thank you,
Mike

Mark O'Brien · Apr 23rd, 2002, 10:59 AM

Have you tried disablng macros when you open it up? You should still be able to see your code then.

thewesties · Apr 23rd, 2002, 11:03 AM

Mark,
Thank you for replying so quickly.
???
Tools --> Options--> General Tab --> Check-off 'Macro Virus Protection'
Is this what you mean?

Mark O'Brien · Apr 23rd, 2002, 11:05 AM

No, when you open the workbook, does it ask you to Enable or Disable macros? It may not do this if security is set to "Low" in your Excel.

EDIT:: Go to Tools|Macros|Security and make sure it is set to Medium.
_________________
[b] Mark O'Brien

[ This Message was edited by: Mark O'Brien on 2002-04-23 10:07 ]

thewesties · Apr 23rd, 2002, 11:06 AM

No, it does not prompt for this.
How do I adjust the security settings?

Mark O'Brien · Apr 23rd, 2002, 11:08 AM

Damn, I knew you'd ask that while I was editing.

Go to Tools|Macros|Security and make sure it is set to Medium.

thewesties · Apr 23rd, 2002, 11:10 AM

I have Excel 97 SR-2

I show Tools -> Macro -> Macros...
Record New Macro...
Visual Basic Editor..

That's it

Mark O'Brien · Apr 23rd, 2002, 11:14 AM

I guess go with what you said before:

Quote:

Tools --> Options--> General Tab --> Check-off 'Macro Virus Protection'

Long time, no Excel 97.

thewesties · Apr 23rd, 2002, 11:18 AM

Unfortunately (for me) that isn't working.

As the sweat beads off my head and my cube begins to fill with my hair which is falling out, I ask...
Is there any way to open while holding specific keys or through the run command to enable some kind of switch to perhaps opene step-by-step or with code disabled in 97???

charlie79 · Apr 23rd, 2002, 11:28 AM

You are sure you have macro virus protection checked in the tools -> options -> General Tab?

I just tried it on a machine with xl97, and with that option unchecked, it does not ask, it simply enables macros, with it checked it asks me whether I want to enable or not.

If all else fails, try holding the shift key when you open the file

[ This Message was edited by: charlie79 on 2002-04-23 10:29 ]

Apr 23rd, 2002, 11:08 AM	#6
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	Damn, I knew you'd ask that while I was editing. Go to Tools\|Macros\|Security and make sure it is set to Medium. __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 23rd, 2002, 10:50 AM	#1
thewesties Board Regular Join Date: Apr 2002 Location: Superfund, NJ Posts: 75	I have been developing a spreadsheet project for the past two months. I have made backups of the original workbook regularly. However, over the past 2 days I have made major changes and developments. Now, I try to open the file, it goes through the motions of opening it, gets to about 75 percent then quits. Is there a way to open the file in safe mode (or similar) so I may view the VBA to make sure there is no bad scripting. The last time I accessed it was about an hour and a half ago (with no problems). I have tried opening with other versions of Excel...no good. I have linked to the workbook. the links work, so I know the data is there. I have rebooted. I have lost half of my hair.... PLEASE HELP!!!! Thank you, Mike

Apr 23rd, 2002, 10:59 AM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	Have you tried disablng macros when you open it up? You should still be able to see your code then.

Apr 23rd, 2002, 11:03 AM	#3
thewesties Board Regular Join Date: Apr 2002 Location: Superfund, NJ Posts: 75	Mark, Thank you for replying so quickly. ??? Tools --> Options--> General Tab --> Check-off 'Macro Virus Protection' Is this what you mean?

Apr 23rd, 2002, 11:05 AM	#4
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	No, when you open the workbook, does it ask you to Enable or Disable macros? It may not do this if security is set to "Low" in your Excel. EDIT:: Go to Tools\|Macros\|Security and make sure it is set to Medium. _________________ [b] Mark O'Brien [ This Message was edited by: Mark O'Brien on 2002-04-23 10:07 ]

Apr 23rd, 2002, 11:06 AM	#5
thewesties Board Regular Join Date: Apr 2002 Location: Superfund, NJ Posts: 75	No, it does not prompt for this. How do I adjust the security settings?

Apr 23rd, 2002, 11:10 AM	#7
thewesties Board Regular Join Date: Apr 2002 Location: Superfund, NJ Posts: 75	I have Excel 97 SR-2 I show Tools -> Macro -> Macros... Record New Macro... Visual Basic Editor.. That's it

Apr 23rd, 2002, 11:18 AM	#9
thewesties Board Regular Join Date: Apr 2002 Location: Superfund, NJ Posts: 75	Unfortunately (for me) that isn't working. As the sweat beads off my head and my cube begins to fill with my hair which is falling out, I ask... Is there any way to open while holding specific keys or through the run command to enable some kind of switch to perhaps opene step-by-step or with code disabled in 97???

Apr 23rd, 2002, 11:28 AM	#10
charlie79 Board Regular Join Date: Feb 2002 Posts: 97	You are sure you have macro virus protection checked in the tools -> options -> General Tab? I just tried it on a machine with xl97, and with that option unchecked, it does not ask, it simply enables macros, with it checked it asks me whether I want to enable or not. If all else fails, try holding the shift key when you open the file [ This Message was edited by: charlie79 on 2002-04-23 10:29 ]