VBA - Run macro if last day of the week

[OldAndWeak182]

Hello,
My example: in A I have the 5 days of the working week and a list of stuff next to.
Every 5 days I create a summary of the week in 2 rows (with formula).
After this I created a button that runs a macro that copies the table format and formula extending next 5 days and creates the weekly report rows.
I would like it to run the macro by itself when it reaches the 5th day of the week. I hope I was clear, I have a bit of difficulty in translating...

Max

 

[OldAndWeak182]

My code doesn't need the column to be a date ! and doesn't use it as a variable !
The code I provided counts the cells from col "B" to Col "Q" If the are ALL blank it then moves onto
If today is Friday... run the code
nothing to do with what is in Col "A"

I didn't understand anything LOL.
Then I might have a problem because it is not said that the sheet will be opened on Friday, my aim is to make sure that when any cell of every Friday "of the date column" is filled then it has to run the macro. To do this I thought I could rely on column A but it is not formatted as a date because otherwise I would not be able to do the "trick" of copying the standard from the "layout" tab. I have no other ideas ...

 

[OldAndWeak182]

Nothing?

 

[Michael M]

You won't be able to automatically run a macro in a closed workbook, unless it is called from another Open workbook.