Worksheet Open??

Posted by Alan C on November 22, 2001 7:29 PM

Hi,

I want to load values and default settings into a worksheet upon opening. This will overwrite any previous saved settings. I have no problem with the code for this. Where I am struggling is the trigger for the event. I have tried Worksheet.activate but this also operates when I tab between sheets which is no good.

Any suggestions?

Thanks

Alan C

Posted by Walter on November 22, 2001 7:54 PM

Put it inside

Sub Workbook_Open()
End Sub

of ThisWorkbook

Posted by Alan C on November 23, 2001 12:32 AM

Re: Worksheet Open and it works Thanks