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

  • Thread starter Thread starter maurim
  • Start date Start date
M

maurim

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
 
Disable macros thru the security settings then you will be able to open the
workbook and delete the macro.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to force macros refer to ActiveWorkbook 2
Converting a “Delete Column” Macro to a “Delete Row” Macro 7
delete cell value if there is data validation error 10
write vba to a worksheet via a macro 3
Trying to recover deleted macros 0
Macro to delete last entry of a column 5
Macro to delete an Object 1
Error deleting worksheet (Excel 2003) 2

Back
Top