This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 90%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEM%3C/text%3E%3C/svg%3E)
I have a vba code that i created for one of the excel sheets that would autofill rest of the city name and state after I enter the first 3 letters of the city and press enter. Unfortunately, it is active across my whole Excel app, I deleted it, I has Microsoft office team access the computer as well, no one can fix it. Please help delete it and inactivate the code.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 53%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
If the code is active for every workbook, then it must be located in an area common to all. This is usually in the PERSONAL.xlsb file commonly located at C:\Users*your-name*\AppData|Roaming\Microsoft\Excel\XLSTART.
If you press Alt-F8, does the name of your code show up in the list of available macros?
If you press Alt-F11, can you see the module containing your code in the list of modules for any open workbook, including PERSONAL.xlsb?
So there is no PERSONAL.xlsb that can be located.
Answer is no for both questions
So where is your code located?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(9.6, 52%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Hi Eldar Muradov,
Just set sheet name what you desired. then check condition to your VBA code sheet name should be the your desired name. then it will not execute any other sheets.
Thanks.