Workbook with macro unvisable in VBE

  • Thread starter Thread starter mohavv
  • Start date Start date
M

mohavv

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
 
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"
<[email protected]>
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
 
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, USAhttp://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)

"mohavv"
<[email protected]>
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
Click to expand...

Tx, but no luck.
The error refers to a sheet that is not visible (called "M"). If I try
to insert a sheet with the same name it won't let me cause it already
exists.
It doesn't show in VBE either.
The error is in cell M!A3 and is: =select("R1C1") and I got following
options: Step into, Evaluate, Halt, Goto, Step over, Pause, Continue
and Help.
After clicking Step into the following appears for cell M!A4: =halt()
with the same options.

Does this ring a bell?

Cheers,

Harold
 
Harold,
Sounds like you have an XL4 Macro sheet in the workbook.
The code is contained in the sheet itself.
You should be able to make the sheet visible using Format | Sheet | Unhide.
Or the following code should work... Sheets("M").Visible = True
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"mohavv"
wrote in message
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, USAhttp://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)

"mohavv"
<[email protected]>
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
Click to expand...

Tx, but no luck.
The error refers to a sheet that is not visible (called "M"). If I try
to insert a sheet with the same name it won't let me cause it already
exists.
It doesn't show in VBE either.
The error is in cell M!A3 and is: =select("R1C1") and I got following
options: Step into, Evaluate, Halt, Goto, Step over, Pause, Continue
and Help.
After clicking Step into the following appears for cell M!A4: =halt()
with the same options.

Does this ring a bell?

Cheers,

Harold
 
Back
Top