Corrupted Sheet

[jayanderson]

When I try to run code behind a worksheet or reference anything on the sheet I get error 32809. Embedded buttons on sheet exist but do not show any properties. When I move worksheet to a new book then move back code behind sheet works fine and sheet is usable again. I presume file lost something with namespace but wondering if there is any easy way to fix versus the moving?

[abousetta]

Hi,

Have you tried cleaning the code?

Code Cleaner

abousetta

[royUK]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

[jayanderson]

Attached is the workbook with the problem sheet called Setup. Ctrl+m shows the form Menu_Main, which errors out during initiation because it tries to reference a cell on Setup.

In Module 1 is the routine Protect_worksheets, which calls Lock_worksheets, which walks through each sheet and protects it. What is interesting is that in the locals window Setup is listed as type worksheet/worksheet instead of worksheet/Sheet1.

If I delete enough code in other places all of the routines suddenly start working properly. Moving the sheet to another file and back works as well. Now I am wondering if there is a way to Excel clean itself up versus doing someting like the code cleaner mentioned?

Thanks

Jay