How can I delete all macros?

[Pheasant Plucker®]

Hi there,

I have an invoice spreadsheet based upon the Village Software invoice.

There is a date cell that automatically puts in today's date but I see no
formula for that particular cell.

There are however some macros that appear if I run the VB Editor - I still
do not see the date macro (if any)

As this is causing me a lot of grief is there a way I can disable all macros
so I am not prompted to enable or disable macros when opening the sheet?

I have tried all sorts of things but I either still get the prompt, the date
still tries to update or I get error messages telling me it cannot find
!CloakSheet or other cryptic messages.

There is also a Winfax macro I can see in the VB Editor...

All I want is to be able to open up the spreadsheet with no damn macros!

 

[Bob Phillips]

Check out http://www.contextures.com/xlfaqMac.html#NoMacros

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Gord Dibben]

If you can see the code, you can delete the module.

With Invoice workbook open, go to VB Editoe and click on Modules to expand.

Right-click on "Macros" and remove module.

Hit NO when asked to export.

Go back to Excel and File>Save As>File Type>MS Excel Template(*.xlt)

Let it overwrite the original.


Gord Dibben MS Excel MVP

 

[Harald Staff]

Hit NO when asked to export. (...)
Let it overwrite the original.

This is confident advice to a beginner, Gord <g>.
Quoting one of my former bosses: "Throw everything out. Create two copies
first."

Best wishes Harald

 

[Gord Dibben]

Bob

The INVOICE.XLT shipped with versions before 2002 included macros.

The "contains macros" message is for real.


Gord

 

[Gord Dibben]

I see no point in keeping the original hanging around as a potential conflictor.

But.......copy doesn't take up much room.


Gord

 

[Gord Dibben]

BTW.........no smokes since February 4th.

Had my last one while waiting for the Ambulance to take me to Emergency with
heart problems<g>


Gord

This is confident advice to a beginner, Gord <g>.
Quoting one of my former bosses: "Throw everything out. Create two copies
first."

Best wishes Harald

Gord Dibben MS Excel MVP

 

[Dave Peterson]

It always struck me as kind of funny (in the odd sense) when I would drive past
the cancer clinic at the local hospital. There would always be a bunch of
people hanging around the entrance smoking.

Congrats on your willpower!

 

[Bob Phillips]

Thanks Gord, can't say I have ever used it.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Bob Phillips]

Yeah, but that would be the young people who work there, still carrying the
folly of youth.

Seconded on the congrats Gord.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Dave Peterson]

Lots of older (mature???) husbands and wives and family who were visiting, too.

<sigh>

 

[Harald Staff]

Good work, Gord ! I'm glad they fixed your heart.
(Hope you'll gain less weight than I've done after quitting ;-)

Best wishes Harald

 

[mrice]

Have you looked on the ThisWorkbook tab in the VB editor. There may be
Workbook_Open macro lurking there

 

[Pheasant Plucker®]

Thanks for the reply Gord,

Everything went well up until the stage where you suggest I save the
template - I cannot seem to find the original template...

I can save the worksheet but when I open it again I still get the enable
macro prompt.

When I enable I then get the error message;
"No RETURN() or HALT() function found on macro sheet"

Thanks for your time.

Kind regards,
-=pp=-

 

[Pheasant Plucker®]

Thanks for the advice Bob,

I saw this link while I was trawling this ng for a previous fix but it still
doesn't work.

I followed the instructions and ended up removing what looked like 3
macros - one called Macro, numbering & Winfax.

Saved from within VB Editor, saved the spreadsheet & exited Excel.

Opened up the spreadsheet but still prompted to enable macros :-(

I cannot see anything else anywhere.

Thanks for your time.

Kind regards,
-=pp=-

 

[Chip Pearson]

Smoking outside the door is a fabulous social/occupational
leveler. Out by the door, there are no lords and no serfs.
Everyone is just a smoker, an equal among the many, sharing a
guilty pleasure, and embracing the scorn of the non-smokers. LOTS
of juicy gossip passes through a good smoke session.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Gord Dibben]

I was meaning for you to save the modified workbook as a Template.

I don't know why you're still getting the "enable macros" message.

My version has only one module and no event code in sheets or workbook.

As far as the "no halt or return" message..............

Maybe the information on this link can help you:

http://support.microsoft.com/default.aspx?scid=kb;en-us;316399

If you want to send me the workbook I'll take a look at it.

Change the AT and DOT to @ and .


Gord

 

[Gord Dibben]

Chip

I must confess....I miss the socializing part.


Gord

Smoking outside the door is a fabulous social/occupational
leveler. Out by the door, there are no lords and no serfs.
Everyone is just a smoker, an equal among the many, sharing a
guilty pleasure, and embracing the scorn of the non-smokers. LOTS
of juicy gossip passes through a good smoke session.

Gord Dibben MS Excel MVP

 

[Ragdyer]

If you can get by the morning cup of coffee, and the evenings at the local
tavern, you're 90% home!<bg>

Still had the alcohol to contribute to the socializing, while everyone
else's smoke drifted by the nose
That was the hardest challenge for me.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

Chip

I must confess....I miss the socializing part.


Gord

 

[Pheasant Plucker®]

I was meaning for you to save the modified workbook as a Template.

I don't know why you're still getting the "enable macros" message.

My version has only one module and no event code in sheets or workbook.

As far as the "no halt or return" message..............

Maybe the information on this link can help you:

http://support.microsoft.com/default.aspx?scid=kb;en-us;316399

If you want to send me the workbook I'll take a look at it.

Change the AT and DOT to @ and .


Gord

Thanks very much for the reply Gord - and good luck with kicking the habit!

My girlfriends Mum has just had her leg amputated after suffering much pain
& grief - the doctor's said that smoking was to blame.

She however can't/won't stop smoking...<sigh>

Back to business - I took a look at the link and it did not help.

I did however find a link in another thread to an add-in by Bill Manville
called FindLink - http://www.oaltd.co.uk/MVP/Default.htm - I downloaded,
installed as an Add-In and ran it - that seemed to work but when I go into
the VB Editor I see an entry for FindLink that is password protected(!?) so
I can't actually see into it...

I might take you up on your generous offer and send the workbook for you to
take a look at though...

Many thanks & regards,
-=pp=-