Creating a macro that is "editable" in an excel file.

[Harlort]

Hi all,

I need some help from the expertise.

I want to create a macro that is editable in an excel file. What I mean is that the code is visual in the file and for example the file location of the files to be opened are visable as well.

If I could get some hints or links on how to do this I'd be very happy. I have created a simple excel file to try to visualize my idea what I would like the macro to do.

The thing is that I've seen this being done but I don't really know the best way of doing it.

Thanks
Niklas