I had similar problem. Is your macro in a button? I designed variant
workbooks using one as a template. I would change the macro and save the
workbook to a new name. I had installed buttons to call the macros. The
damned buttons remembered the OLD macros and would find that old
workbook, open it, and call that macro instead of my new one. I
discovered the macros were stored as if the workbook was part of the
path name to the macro... something like that.
What happens if you delete the other workbook? Or rename it?
John
Len wrote:
> John;
> My name is Len. I have been watching the Users Group all day to get
> some ideas. I noticied you are having some of the same issues I am. I get
> the same thing, I open one WorkBook and another that has no relation to it
> opens up when I run a Macro. I called Microsoft this AM and paid $490.00 and
> they still have not found the problem. I am sure the school district is not
> going to reimburse me.
>
> On your Macros disappearing. I had the same problem in the begining.
> I had to start completely over and it seemed to help a lot.
>
> Is your WorkBook very large? Mine is 15,000 lines and 264 columns. I
> am trying to make it smaller so it can be manageable and I am struggeling
> with it. Like yourself my Excel knowledge is very limited.
>
> Good Luck
>
> Len
>
> "John Quinn" wrote:
>
>
>>It is This Workbook, One of the seven Macros keeps reverting back to All
>>Books, I change it every time I load the Workbook????
>>
>>There is only one other WorkBook with Macros in it and they are both This
>>Workbook.
>>
>>We send the University a file from a SQL Server and they send us back a
>>Workbook is sent back to us from a University. We then have to come up with
>>our own reports from the Workbook they send us. However I have to program
>>the Macros because they are far to complex to dp the selections manually.
>>
>>For now I have been burning a CD and bringing that .xls back in. By the way
>>about four days ago I saw someone else having the same problem????
>>
>>Thanks Again
>>
>>J.Q.
>>
>>"(E-Mail Removed)" wrote:
>>
>>
>>>On Jul 5, 1:32 pm, John Quinn <JohnQu...@discussions.microsoft.com>
>>>wrote:
>>>
>>>>When I go to run my Macro, If I get a Halt something happens. It tell's me
>>>>the Macro is not there and then I have to recode the entire Macro.
>>>>
>>>>I have tried everything and am getting nowhere. I keep telling saving it as
>>>>this WorkSheet Only. Why does it keep wiping out in all me folders.
>>>>Standard Procedures for taking caution do not apply to Excel!
>>>>
>>>>Does anyone have an idea where I can go to find out if this can be done?
>>>>
>>>>It has been five weeks now and I have to burn a CD every time to save what I
>>>>have done!
>>>>
>>>
>>>You aren't telling us what the macro is doing or why it is halting.
>>>
>>>I write macros in master sheets every day that I save before running
>>>and they are still there after they run and the next time I open that
>>>sheet in Excel. 1,000s of other people do the same thing.
>>>
>>>Are you saving a macro attached to a worksheet or a workbook?
>>>Peter
>>>
>>>
|
Similar Threads
