Macro codes automatically opens when opening a excel file
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.
|