two questions referencing a cell in a macro for folder and running a macro on one sheet

Hi there! I have 2 questions, but first I will input the code:

Please Login or Register  to view this content.

So this formula works great except for 2 things - It runs on every workbook, I want to limit it just to the workbook and sheet I'm in. I also don't even need it to be running in the foreground and would prefer it just run silently in the background no matter what others worksheets or workbooks I am in, as long as this one is open.

The other problem I have is instead of C:\Users\blue\Documents" I want it to read blue as a variable that I input on lets say Sheet "Y". So if sheet Y has "blue" in Cell A1, and I change is to "red", the macro will look for C:\Users\red\Documents" instead.

Thank you for your help!