Assigning macro to control box on phone log sheet

[blinhart]

I had a log sheet I created to log calls by year. On the main page there was a button that was created that opened a box that I could enter all the data into. On the bottom in the control box then where you could email to supervisors, save to logsheet that you selected from the drop down list by year you were saving to. I went to open the file today and am getting an error and not sure what happened to the macro that was assigned to the button and not sure what happened. I have attached the file, but I can't find the macro assigned and don't remember who helped me create the macro before. Can someone tell me what is error is and help me to fix if possible?

[bakerman2]

I am a bit confused because all the code is present in your file.

When and what is the error message your getting ?

[alansidman]

@blinhart

Your attachment contained multiple instances of personal information which is inappropriate for public dissemination. As such, I have removed the file from the forum. Would you please attach a new file which anonimizes the personal information that was in the file you posted. I am sure you understand our concerns with the public dissemination of personal information in today's world of hacking such type of data.

Alan

[blinhart]

Can't find project or library. It won't open the control box or let me make changes to the file and save.

[blinhart]

I was going to do that but it won't let me save the file if I delete any information and try to save as a blank copy. Sorry - I guess I will have to try to figure out and recreate something. I keep getting the same "can't find project or library" error and it then shuts all my excel files that I have open.

[alansidman]

Have you opened the VBE and clicked on tools-->References and determined if there are missing items. Then making sure that the missing items are located and clicked so that you have the references installed.

[blinhart]

I did try that and it won't open the reference box. I looks like when excel is "not responding" and the reference box only half way appears and never fully opens to be able to see the code. I don't see anything but the frame of the box.

[bakerman2]

In VBEditor go to Tools - References.

Is there any Reference that says missing ?

If so uncheck it and save the file.

[alansidman]

Have you tried closing Excel and Windows and rebooting your machine. I wonder if your copy of Excel has become corrupted. Do all other Excel Workbooks open and work as designed??

[blinhart]

I did try all that first. I had to restore to a previous version by right clicking on the file and selecting to restore to a previous version, but file is fixed. Thanks for all your help on this.