Paul, thank you, that worked ... with all the worms going
around, the updates must have set it to high security
because i've never had to do this before... Peter

-----Original Message-----
Peter, you need to change the macro security settings to
get the macro to
run. using 97 right now but I think it is under tools,
macros, security

--
Paul B
Always backup your data before trying something new
Using Excel 97 & 2000
Please post any response to the newsgroups so others can
benefit from it
** remove news from my email address to reply by email **

"Peter Wiley" wrote in message
...
I recently had to rebuild my hard drive and I
reinstalled
Windows and Office 2000 with all updates. Now my excel
spreadsheets don't work because the macros are
automatically disabled -- I no longer get the prompt to
enbable/disable macros when I open a spreadsheet. A
couple
of these are critical to my business. Any ideas?


.