View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nigel[_2_] Nigel[_2_] is offline
external usenet poster
 
Posts: 735
Default Macro codes automatically opens when opening a excel file

Is the VBE opening because of an error?

Post your code, it is impossible to diagnose the problem without it. --

Regards,
Nigel




"Vaibhav Bhawsar" <Vaibhav
wrote in
message ...
I have coded a macro for MS excel 2007. The macro has been placed under
Workbook_open event. It works fine as expected but it also opens the
Visual
Basic editor auomatically displaying the macro codealong with excel sheet.
I
tested the same by saving in Excel 2003 format. The same problem exists.