Changes Macro from WorkSheet to All Books

[Guest]

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!

J.Q.

 

[par_60056]

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

 

[Guest]

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.

 

[Guest]

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]

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

 

[Vasant Nanavati]

I'm really having a lot of trouble understannding what you all are talking
about.
________________________________________________________________________

 

[John]

you should talk. what in the world does this sentence mean?

"There is only one other WorkBook with Macros in it and they are both
This Workbook."

Is the name of your workbook "This Workbook?"

John

 

[Vasant Nanavati]

???

I was not the one who wrote that.
__________________________________________________________________________