Unable to identify where it VBA it is looking to open a folder.

[Godders199]

I am running some old code, and during the programme , it opens a window for one of my folders, as if it is looking for data or saving , if i press cancel on the window the code continues to run and completes. All the data is correct so if clearly does not need whatever may have been in that folder

I have gone through the code and can find no reference to it doing anything outside the the workbook.

Is there anyway to establish where in the code it opens this folder?

 

[RoryA]

Does the code input any formulas?

 

[Godders199]

yes in to one of the tabs , but only cross referencing with other worksheets in the same workbook

 

[RoryA]

If the sheet name is wrong in any of the formulas, you would see a dialog (usually says something like "Update values: sheet name" in the title bar) prompting for the location.

 

[Godders199]

ok thanks , will look through the formulas