I'd double check that you're putting the code in the correct workbook's project.

And I'd double check that you're opening the file that was saved with those
changes.

If you've done that and it didn't help, do you have any antivirus software that
could be "helping"?



Jaime wrote:

I am having the same problem with 2003 version. I create a VB subroutine,
and then save the spreadsheet. When I reopen the spreadsheet the VB
subroutine is gone. Any help would be appreaciated.

"Shane Devenshire" wrote:

Hi,

I don't thing there is any way in 2000 of saving an Excel file which
contains a macro and have the macro remove. That can happen in 2007.

Are you recording your macro? If so are you recording it into the Personal
Macro Workbook instead of this workbook?

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"John" wrote:

I installed Office 2000 on a new comuter (Vista). When I save an Excel
program with a VB subroutine--the sub is apparently not saved??
Thanks

--

Dave Peterson