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!