Excel VB code isn't working
Posted on 2015-02-03
I have a spreadsheet that I have done some VB code in it. Over the past couple of weeks the codes have stopped working. It was suggested that I look for *.exd files delete them and that would resolve my problem. It did the first time but now I keep getting these two files MSForms.exd and RefEdit.exd that pop up each time I open my database. I delete them multiple times and ever time I open the database these keep occurring. Once I delete them and then open the database and I get a runtime error of 32809, application-defined or object defined error. I had never had this issue before. When I debug it I see that I had put some code in "ThisWORKBOOK" that basically called up the Home page as I wanted users who open the workbook to get the home page which has some button navigation on it for them. The code says that Sheets("Home").Activate is where the issue resides, but this has worked for the last 5 months without issue. I have checked to make sure that under Macro security Enable all macros is selected but none of my code works now. But none of my macros work now. I tried uploading the file but it tells me that a virus was detected in the uploaded file. How do I scan the file and fix or remove it. I am on a locked odwon PC and have win7 and office 2010. Can anyone help me here?