debugger, how do I turn it off?

[Vato Loco]

Can someone Please help me shut off the debugger in excel 97?

Thanks, Vat

 

[Bob Phillips]

What exactly do you mean? What is happening that you don't want?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Vato Loco]

I have a workbook that is using the code below, but is returning a "ru
time error 1004" message if I click "no" to save.

ActiveWorkbook.SaveAs FileName:=ActiveSheet.Range("b105")

Vat

 

[Bob Phillips]

Then that is an error which you need to resolve.

Check what is in B105, and sort it out.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Vato Loco]

Thanks Bob, Have a good one!

 

[Harald Staff]

Then it's the application refusing to do what your code instructs it to
because it's impossible. The debugger is not the bad guy here, it's your
code.

HTH. Best wishes Harald