View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_5_] Dave Peterson[_5_] is offline
external usenet poster
 
Posts: 1,758
Default VB Code Remains In Memory

I've seen it xl97 and win98.

I current use xl2002 and win98 at home. I've seen it there, too.

I use xl2k and win2k at work and have seen it there.

I don't use the google desktop search anywhere.

Aside from being an irritant, I've never seen it cause trouble for me. And if
I'm really irritated, I close and reopen excel.



Paul Moles wrote:

Seems to be an Office 2003 phenomenon as removing Google toolbar on this
machine doesn't change VB behaviour,(don't have a virgin 2003 machine to
check for orphaned files) but on Office Xp machines even with Google toolbar,
VB is as expected and closes with Workbook. All machines Win Xp.

Any other suggestions?

"Paul Moles" wrote:

I have on this machine will have to check user machines, where google toolbar
will not be present, to see if VB behaves differently.

Thanks

Paul

"Tom Ogilvy" wrote:

Do you have the google toolbar installed? I understand it causes this
problem.

--
Regards,
Tom Ogilvy

"Paul Moles" wrote in message
...
I have a workbook with several Macros, if the workbook is closed but Excel
left open, (using close window "x" or File Close)The Macro code remains in
the visual basic editor and can even become duplicated/triplicated if the
workbook is susequently reopened in the same Excel session.

The workbook includes Auto_Open and Workbook_BeforeClose macros but
neither
have contents that would suggest or require this activity.

Is this normal behaviour? if so what is its purpose and is it possible to
change it so the Visual Basic code closes when the Workbook is closed.

Thanks







--

Dave Peterson