View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Workbook with macro unvisable in VBE

Harold,
Have you checked the code in the error handling routines?
Also, do a search in the VBE, within the entire project, for "MsgBox".
If you don't find it then it is not a VBA MsgBox.
It might be a custom form that is displayed.
Do a project wide search for a phrase from the displayed message
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"mohavv"

wrote in message
Hi,
I'm working on a workbook (XL 2003) with an appearing macro on opening
(msgbox) which contains an error. It refers to a non existing sheet,
according to the message.
However I can't find the code in VBE, not in the modules, ThisWorkbook
or Sheets.
Anyone an idea where it can be stored?
Cheers,
Harold