Thread
:
Macro codes automatically opens when opening a excel file
View Single Post
#
2
Posted to microsoft.public.excel.programming
Nigel[_2_]
external usenet poster
Posts: 735
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.
Reply With Quote
Nigel[_2_]
View Public Profile
Find all posts by Nigel[_2_]