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!

--
Thanks & regards,
-pp-

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

--
HTH

Bob Phillips

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

"Pheasant Plucker®" wrote in message
...
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!

--
Thanks & regards,
-pp-

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 FileSave AsFile TypeMS Excel Template(*.xlt)

Let it overwrite the original.


Gord Dibben MS Excel MVP

On Wed, 26 Jul 2006 18:28:45 +0100, "Pheasant Plucker®"
wrote:

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!

"Gord Dibben" <gorddibbATshawDOTca skrev i melding
...

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

Bob

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

The "contains macros" message is for real.


Gord

On Wed, 26 Jul 2006 18:57:44 +0100, "Bob Phillips"
wrote:

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

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

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


Gord

On Wed, 26 Jul 2006 20:22:26 +0200, "Harald Staff"
wrote:

"Gord Dibben" <gorddibbATshawDOTca skrev i melding
.. .

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

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

On Wed, 26 Jul 2006 20:22:26 +0200, "Harald Staff"
wrote:

"Gord Dibben" <gorddibbATshawDOTca skrev i melding
.. .

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 MS Excel MVP

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!

Gord Dibben wrote:

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

On Wed, 26 Jul 2006 20:22:26 +0200, "Harald Staff"
wrote:

"Gord Dibben" <gorddibbATshawDOTca skrev i melding
.. .

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 MS Excel MVP

--

Dave Peterson

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

--
HTH

Bob Phillips

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

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Bob

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

The "contains macros" message is for real.


Gord

On Wed, 26 Jul 2006 18:57:44 +0100, "Bob Phillips"
wrote:

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

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" wrote in message
...
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!

Gord Dibben wrote:

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

On Wed, 26 Jul 2006 20:22:26 +0200, "Harald Staff"

wrote:

"Gord Dibben" <gorddibbATshawDOTca skrev i melding
.. .

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 MS Excel MVP

--

Dave Peterson

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

<sigh

Bob Phillips wrote:

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" wrote in message
...
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!

Gord Dibben wrote:

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

On Wed, 26 Jul 2006 20:22:26 +0200, "Harald Staff"

wrote:

"Gord Dibben" <gorddibbATshawDOTca skrev i melding
.. .

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 MS Excel MVP

--

Dave Peterson

--

Dave Peterson

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

"Gord Dibben" <gorddibbATshawDOTca skrev i melding
...
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

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


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=565258

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=-



"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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 FileSave AsFile TypeMS Excel Template(*.xlt)

Let it overwrite the original.


Gord Dibben MS Excel MVP

On Wed, 26 Jul 2006 18:28:45 +0100, "Pheasant Plucker®"

wrote:

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!

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=-

"Bob Phillips" wrote in message
...
Check out http://www.contextures.com/xlfaqMac.html#NoMacros

--
HTH

Bob Phillips

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

"Pheasant Plucker®" wrote in message
...
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!

--
Thanks & regards,
-pp-

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





"Dave Peterson" wrote in message
...
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!

Gord Dibben wrote:

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

On Wed, 26 Jul 2006 20:22:26 +0200, "Harald Staff"

wrote:

"Gord Dibben" <gorddibbATshawDOTca skrev i melding
.. .

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 MS Excel MVP

--

Dave Peterson

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...b;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


On Wed, 26 Jul 2006 23:54:38 +0100, "Pheasant Plucker®"
wrote:

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=-



"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .
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 FileSave AsFile TypeMS Excel Template(*.xlt)

Let it overwrite the original.


Gord Dibben MS Excel MVP

On Wed, 26 Jul 2006 18:28:45 +0100, "Pheasant Plucker®"

wrote:

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!

Chip

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


Gord

On Wed, 26 Jul 2006 21:59:03 -0500, "Chip Pearson" wrote:

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

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 !
---------------------------------------------------------------------------
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Chip

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


Gord

On Wed, 26 Jul 2006 21:59:03 -0500, "Chip Pearson"
wrote:

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

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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...b;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=-

As a non-smoker, I like to cough (excessively, <bg) each time I walk through
the smoke gauntlet. I don't think the smokers have ever get tired of it!



Chip Pearson wrote:

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

"Dave Peterson" wrote in message
...
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!

Gord Dibben wrote:

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

On Wed, 26 Jul 2006 20:22:26 +0200, "Harald Staff"

wrote:

"Gord Dibben" <gorddibbATshawDOTca skrev i melding
.. .

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 MS Excel MVP

--

Dave Peterson

--

Dave Peterson