Desperate, Catastrophic Error

[Aleciafxc]

I will be specific as i can.

I know what the visual basic editor looks like with normal sheet code. Sheet1(name). It seems I have done something very wrong and can not figure it out. Now, in the visual basic editor, the Sheet Name is sheet1 with a little plain white sheet with the little excel logo this contains the code, listed as sheet1, and now the actual "data" sheet is there with what looks like the normal logo with no code. Is is like the sheet code is separated from the actual sheet. No sheet Macros works when the regular sheet is open. Some other macros work that are in the modules.

I am really in need of serious help, which brings me to another question. How can I find someone local that knows Excel Visual Basic? Do I contact Colleges, i am at a loss. The local Technical School is no help, I was the excel instructor, but not advanced macros (just good and formulas et. al.), this website is the only assistance I have had. What I have no experience in is errors and why they happen. I am in need of professional assistance which I am willing to pay for. Please Advise. Any of you Mr Excel pros in Missouri, Kansas or Oklahoma. I am Serious.

Anything will help.

Alecia

 

[Colin Legg]

So i am not crazy. Ok, I have deleted a few worksheets in the workbook, by right clicking the sheet name and choose delete. There were active controls on the sheet but non were active at the time, at least I do not think they were. This makes alot of sense to me. All of my sheets had the code separated from them, not just one??? Can I fix this and have the code reconnect to the sheet or should I get a previous copy and rebuild from there?? What would your advise be.

Thanks
Alecia

This sounds like a fringe case - I've not heard of this happening across all sheets simultaneously before. I'd be interested to see the workbook itself to make sure that what we are both talking about is the same thing. Can you upload it somewhere for me to see (you can't attach workbooks to threads in this forum)?

The example I gave is just one way of "achieving" the effect; there are bound to be others.

 

[Aleciafxc]

Can't send the database it is full of our client information. I also cant attach a picture here, this is something you will have to see. It says I can insert a url, but where would i do that.

 

[Norie]

Alecia

Could you please tell us what you are trying to do with this workbook?

Without that information all we can really do is take guesses and make stabs in the dark.

 

[Aleciafxc]

The workbook is a tracks the requirements and timelines for case management duties. We serve 650 people tracking a wide variety of issues. The Workbook contains many sheets, forms, macros, you name it, it has it. If anyone knows how i can upload a picture to here let me know. I have seen some posts where they are images of worksheets, so it must be able to be done.

 

[xenou]

To show an image you generally would have to upload the image to a file-sharing site such as flicker or photobucket (there are numerous others). Then you would drop the link into your thread (often, file sharing sites have them ready to be copied and pasted elsewhere). I doubt you could post an image of your whole workbook but a picture of these strange orphaned sheet modules would be interesting to see ... I personally dislike the advertising that comes with these services (as the "free" variety, anyway) - also, sometimes, when you use their links they take back to their sites (acting as hyperlinks rather than just image resources. So be sure the image link doesn't specify a target webpage. It should be an <img> tag rather than an <a> tag).

 

[Aleciafxc]

I hope this is going to work. To view pictures select link.

Database I call "JARVIS"

JARVIS Good
http://www.flickr.com/photos/48945769@N04/4485031302/



JARVIS Bad
http://www.flickr.com/photos/48945769@N04/4485031326/

 

[Norie]

Alecia

I've looked at both images, but I'm afraid I don't think images are going to help us help you.

Why do you have sheets with codenames that go into the hundreds in the 'bad' example?

That just indicates that there is a problem somewhere, perhaps with code, but you've not posted any code or told us what this workbook is meant to do.

It's awful hard to tell what the problem is without that sort of information.

 

[Colin Legg]

Hi Alicia,

Okay, we are talking about the same thing. The sheet class modules which have the little Excel icon on are toast.

I'd like to test if the corresponding worksheets have been deleted (which is what I expect). Please can you add a standard code module to the workbook, copy and paste in this code, and then run it?

Sub GetCodeNames()
    Dim wst As Worksheet
 
    For Each wst In ThisWorkbook.Worksheets
        Debug.Print wst.CodeName
    Next wst
 
End Sub

It will list all of the existing worksheet codenames in the Immediate Window in the Visual Basic Editor. Please can you post the results on the thread?

 

[Aleciafxc]

Ok, here is the just of my problem that I have been trying to describe. I did not name the sheets this way.

From the begining.

I opened the database and there was a catastrophic error. When I went into the visual basic editor this is what I saw. My original sheet names, ie. sheet16(InDis) was now Sheet161(InDis) with the regular logo beside it and also had sheet16 with the white sheet with the little green logo by it. That is what I was trying to describe, why did this happen. I did not name a sheet - sheet161(InDis). Someone wanted to see what I was talking about that is why I posted the pictures.

 

[Aleciafxc]

My last response was for Norie.

Colin i am adding the code now and will run it in a minute and get back to you.