Thread: Excel not saving Visual Basic sub
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
  
Posts: 3,346
Default Excel not saving Visual Basic sub
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
Reply With QuoteReply With Quote