Request for variable only once when looping throughb workbooks

[kchm_2000]

Currently I have a control workbook that runs macros for all the files in a specific folder.
The macro basically provides a comment whenever the date is lower than the threshold date.

Please Login or Register  to view this content.

However when I loop this across various workbooks using this macro. The date_ref pops up whenever a new loop starts. Is there a way to only input the date_ref once? Thanks for anyone's help in advance. The code for the workbook folder loop is below

Please Login or Register  to view this content.

[JBeaucaire]

Change the ME1 macro to accept an input variable:

Please Login or Register  to view this content.

This version eliminates the "unnecessary selecting".


Then pass that parameter to the macro as you call it:

Please Login or Register  to view this content.

[kchm_2000]

Hi, the date_ref is still popping up each time the workbook loops, is there a way I can place the threshold date on the spreadsheet so that it loops through the control spreadsheet?

[JBeaucaire]

Just move the input command up ahead of the loop.

Please Login or Register  to view this content.

Then, feed the edited macro with that parameter:

Please Login or Register  to view this content.

[kchm_2000]

Thanks it works fine now