One design suggestion: Instead of putting the names of the opened workbooks
in your sheet, how about you have the names there already and just mark them
"open" or "closed" or whatever in a different column? This allows your
program to read the workbooks to open or close without having to have them
hard-coded in the program itself; you or another user could change the list
right there in the worksheet.

But however you do it, you haven't asked your question yet. You want to do
what you've described below, but obviously you've tried that and you're
having a problem; so what's the problem? What did you try, and how is it not
working?

Or is it that you know nothing about VBA programming and don't know how to
start? If it's that, at least say so and maybe someone will be willing to
give you some tutoring. (I probably would, for one, a little at a time.)

--- "Jack" wrote:
i have 6 i would like to open - but not go to each file as it opens - but add
the file name to the current sheet as the files open.

when i close the files i would like to do the opposite and remove the file
name from the current sheet ast the files close. When i close the files 2 of
the files i need to save and the other 4 just close.