I am unable to find "activate " when I right click on worksheet. ( i assume
that you are referring to the windows explorer kind of interface which opens
up on the left of the visula basic window) . Sorry! I am new to excel and
many thanks for your quick response.

"Don Guillett" wrote:

right click on the sheet tabview codeleft window worksheetright window
activate

--
Don Guillett
SalesAid Software

"Excel macro" <Excel wrote in message
...
How do I make a macro run automatically when a worksheet it is attached to
is
loaded?