Excel Workbook Running VBA Code After it Has Been Deleted

[wgilthorpe]

I have a workbook for creating quotations of our products.

In my main user form, I created a button to use

Application.FileDialog(msoFileDialogFilePicker)

to open another excel sheet to import pricing updates. This subroutine was giving me trouble, so I decided to scrap it. I deleted the entire sub.

Now, at random times, the open file dialog box will open. When I close it, it pops right back up. I have searched all the VBA code in the file and I have removed all code that opens this dialog. I have double and triple checked the modules. I am seriously considering starting from scratch.

Has anyone else had a similar experience? Any insight would be appreciated.

 

[AKR22]

It seems that you are calling on the file dialog somewhere. Try putting a break point on the first line of code for the button. Then step through the code to find where this dialog keeps coming up from. Make sure to reset the environment as well.

AKR22

 

[JLGWhiz]

You can pretty much bet that there is code somewhere that is calling the dialog box. Just keep track of what event is initiated prior to the box appearing and it will lead you to where you should look. I suspect it is in a sheet code module embedded in a Worksheet_Change or Worksheet_SelectionChange macro.