Macro to run on file opening

Hi Galina

Thanks for your question

This is easy to do

You need to write your code in the open event of the workbook object

In your VBE look at your project explorer. You will see a module for each worksheet, and one for the workbook. Double click on the workbook module. Above the code window click on the object list (Left most combo, currently showing "General"). Select Workbook from the list.

In the right most (procedure) combo box, choose Open. You will now have created an On Open event. Any code you place in here will run when the workbook opens

Hope this is useful
Regards

stephen