Open Excel file automatically on click with another excel file

[Big_Slick]

I have a excel workbook that I need to put on a company computer. I have protected the file that will not allow anybody to save the contents of the workbook, only use it to generate the required answers and numbers. It changes daily so there is no need to save the info.

There is a cell in one of the worksheets that is a drop down box with Employee names. This worksheet I need to be able for anybody to change as employees come and go. . So I put the source list in another workbook, and linked it to the primary workbook. What I would like to do is have this source workbook open when you open the primary workbook, so the source list is available.

Is there a way to make this source workbook open and close as you open and close the primary workbook.

thanks,

[HaHoBe]

Hi, Big_Slick,

you may use Workbook_Open and Workbook_BeforeClose in ThisWorkbook. Code for Workbook_Open may be like

Please Login or Register  to view this content.

In Workbook_BeforeClose you may use find this helpful

Please Login or Register  to view this content.

If itīs only one workbook you may use the commands to directly handle the workbook instead of looping.

Ciao,
Holger

[Big_Slick]

Holger,

Sorry for my ignorance, but I can't quite make out the code here.

My primary workbook is called (primarybook) and the workbook I need to open is called secondarybook

Could you please help in the code using the workbook names'

thanks