I had an idea a while back which I have been unable to resolve and wondered if anyone knew a solution.

I create funky things that get passed around the office and different people store them in different locations, instead of having to walk around huge offices and changing the code for everyone that uses it I thought I could insert a user form that you can use Application.GetOpenFilename so they can save the document and then enter the file location themselves, which is saved on a hidden sheet in a cell which the code can refer to instead.

E.g.Instead of declaring a folder location in the code (i.e. Set Filepath = "C:\My Computer\My Location\My Folder") is it possible to enter the filepath into an excel cell (for the example A5) and call A5 within the code rather than the location and still declare it as Filepath.