View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gizmo63 Gizmo63 is offline
external usenet poster
 
Posts: 43
Default Closed Macros still visible

Hi guys,

Is anyone aware of an update that has changed the way files can be seen in
the Project Explorer portion of the VBA Editor window?

Something has changed in the last few weeks and now I can see the VBA for
workbooks that are actually closed within Excel.
This proving to be a real pain as over the course of the day I could end up
with 20 files showing - 19 of which are closed!
Closing and re-opening the VBA editor does not clear the list, only closing
Excel clears it.

Any ideas anyone?

Cheers

Giz