Getting Worksheet_Activate to only run when user clicks on the sheet (not at opening file)

[SOLVED]

Hi,

I have a file with several sheets. One of them uses the Worksheet_Activate event. This sub sets Application_EnableEvents to False in the beginning and True at the end. The code works fine. It runs when the sheet is selected by the user.

Now to my problem: When the workbook is opened the Worksheet_Activate code runs. I want the code to only run when the user actually clicks on the sheet.

I have tried to find a way so that the Worksheet_Activate code does not run at opening. I read somewhere that Workbook_Activate does not run until the workbook has finished opening. I don't know if that is true or not but anyway I tried to disable events in Workbook_Open and then enable them again in Workbook_Activate. But no... The disabling works but it is not enabled again when the file has finished opening.

And also: I am worried that I, by messing with events at opening, will mess up something that I am not aware of.

I hope that my description is clear and that someone has a suggestion for how I can solve this.

Thanks in advance.

/Zenita