solved... thanks..

[MaDHaVoK]

I made a Macros in an xls file.... I don't want it now... how do I delete it? I need to give the file to my boss and he doesn't want that macros crap. I deleted the macro but that didn't help... ARG!

 

[ScrapSilicon]

fdisk ..?

 

[ggavinmoss]

When you bring up Tools->Macro->Macros, can't you select them and delete them? Do they just keep coming back?

-geoff

 

[T3C]

Originally posted by: ScrapSilicon
fdisk ..?

 

[loup garou]

This should do it.

 

[HomeBrewerDude]

Tools>Macro>Macros brings up the macro management dialougue box. I think you can delete them there.

 

[ScrapSilicon]

Originally posted by: werk
This should do it.

 

[MaDHaVoK]

I deleted them that way... but that dumb ass box keeps popping up when the file is opened.... plus.... what the macro was doing is still there... I think i need to run something to get rid of the macro.... this is pretty urgent... don't want to lose my summer job over messing up an excel file.

 

[HomeBrewerDude]

you are not communicating very clearly.

Did you "save as" after you deleted the macro? Is your boss using the updated file?

 

[MaDHaVoK]

I have saved the file after deleting the macro... it doesn't appear in the dialog box....

Now the new file still pops up that dumb enable macros.... on anyones machine.... including da boss.
There must be away to remove it.... from the file...

 

[MaDHaVoK]

Score....!!!!!!!!!!!!!!! I got it...... even though you delete the macro you still need to go into the vb editor and delete the empty module.... w000t!

 

[ggavinmoss]

Why not just copy all of the data, formulas, formatting from the macro file and put it in a fresh file with no macros?

-geoff

 

[Toasthead]

Originally posted by: ScrapSilicon
fdisk ..?

haahha that WOULD work