Tequilashot
New Member
- Joined
- Aug 17, 2015
- Messages
- 33
Not an experienced VBA user so I'll just lay it what I did and how the error occurred. Google is not helping.
Created a macro on one of my sheets, simple 1-liner that did a goal seek and was tied to a form button, all good, everything worked as should have done.
Fast forward a few hours later I renamed the sheet (I didn't 'save as', I just edited the name in the folder), the macro had no reference to the file name so I didn't think this would be a problem.
Now when I try to run the macro I get met with the following;
When I go into VBA on the developer tab, the module sheet were I entered the code is now blank.
When I try to record the macro again I am constantly getting met with the following;
I get this error no matter what I try to name the macro so I am confused as to what is the problem. The file is saved as a Macro-Enabled Workbook.
Any help appreciated before I have to revert back to an earlier save and wipe off a few days of work.
Created a macro on one of my sheets, simple 1-liner that did a goal seek and was tied to a form button, all good, everything worked as should have done.
Fast forward a few hours later I renamed the sheet (I didn't 'save as', I just edited the name in the folder), the macro had no reference to the file name so I didn't think this would be a problem.
Now when I try to run the macro I get met with the following;
When I go into VBA on the developer tab, the module sheet were I entered the code is now blank.
When I try to record the macro again I am constantly getting met with the following;
I get this error no matter what I try to name the macro so I am confused as to what is the problem. The file is saved as a Macro-Enabled Workbook.
Any help appreciated before I have to revert back to an earlier save and wipe off a few days of work.