Make Cells Visible Only If Another File Exists

[gwest]

I have a sheet that summarizes data for several scenarios and displays them. Currently, the cells for all scenarios constantly display some data, the data that were the last to be saved as each respective scenario. However, I only want the data to display in the cells if there is actually a corresponding scenario saved in the same path as the current workbook.

My thoughts tell me this would need to be a macro that runs upon the opening of the current workbook. Then it would need to re-execute anytime a new scenario is saved while the current workbook is open (The SaveScenario macro runs from the current workbook, creates the scenario workbook, and copies the scenario summary data into the cells in question).

Please Help.

Thank you very much.

[ragulduy]

As a starting point, you could probably use a function like this:

Please Login or Register  to view this content.

to check if the workbook exists.

Then something along the lines of:

Please Login or Register  to view this content.