Bad Macro References

G

Guest

I copied a worksheet from one workbook to another. Now, in the destination workbook, I have a reference to a maco that does not exist. I believe the original reference in the source workbook may have referred to an old Excel 4 macro. How can I get rid of this reference in my destination workbook? The reference can be found by clicking Tools/Macros from the toolbar. But, the buttons to delete or edit it are grayed out.
 
B

BrianB

old Excel 4 macro
Click to expand...

I would guess this is the case. Try Alt +F11 and clicking in th
worksheet name in the Project Explorer of he VB Editor.

If nothing there I would take a new workbook and copy just th
*contents* of the sheet to a new worksheet via Copy and then Edit/Past
Special Formulas and Edit/Paste Special/Formats. The risk is that th
workbook might become corrupted later on
 

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

Copying a worksheet to another workbook 6
Reference macro in another workbook 1
workbook links 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Word VBA to update cross-referencing 0
macro reference changes with filename 1
macro to filter 6
Using cell as worksheet reference (macro) 1

Top