Trying to delete macro -- 'reference is not valid'
 

I am trying to delete a macro in a worksheet. Apparently, the macro wa
created badly and the message "reference is not valid" appears when
try to do anything -- run, step into, edit, etc. It will not allow
delete. Suggestions

--
mauri
-----------------------------------------------------------------------
maurim's Profile: http://www.excelforum.com/member.php...fo&userid=1485
View this thread: http://www.excelforum.com/showthread.php?threadid=26480

Trying to delete macro -- 'reference is not valid'
 

Disable macros thru the security settings then you will be able to open the
workbook and delete the macro.


"maurim" wrote in message
...

I am trying to delete a macro in a worksheet. Apparently, the macro was
created badly and the message "reference is not valid" appears when I
try to do anything -- run, step into, edit, etc. It will not allow a
delete. Suggestions?


--
maurim
------------------------------------------------------------------------
maurim's Profile:
http://www.excelforum.com/member.php...o&userid=14851
View this thread: http://www.excelforum.com/showthread...hreadid=264806

Trying to delete macro -- 'reference is not valid'
 

Go directly to the VBA editor (ALT+F11)
There should be a window in the top left corner named
Project-VBA Project. if not use CTRL+R and it will appear.
Find the workbook that contains the macro, clik in the +
sign on the Modules folder, find the module that contains
the macro rightclick and choose remove module...

That should eliminate it.

Regards
JS


-----Original Message-----

I am trying to delete a macro in a worksheet.
Apparently, the macro was
created badly and the message "reference is not valid"
appears when I
try to do anything -- run, step into, edit, etc. It will
not allow a
delete. Suggestions?


--
maurim
----------------------------------------------------------
--------------
maurim's Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=14851
View this thread:
http://www.excelforum.com/showthread...hreadid=264806

.