Worksheet Load
 

Hi,

I've already posted on this topic, but for some reason the link to my post
fails and I'm not able to see my post or it comments. So, I'm trying again.

I'm looking to have a group of cells "hidden" once a worksheet loads. I
guess what I need is the Sub for On_Worksheet_Load. Is there such a sub?
Also, is there any way to make just one cell hide? Many thanks.

Worksheet Load
 

On 7 Jun, 15:11, prog wrote:
I'm looking to have a group of cells "hidden" once a worksheet loads. I
guess what I need is the Sub for On_Worksheet_Load. Is there such a sub?
Also, is there any way to make just one cell hide? Many thanks.

As a Worksheet is always contained within a Workbook, you can't
actually open a worksheet on its own, so what you are looking for is
the WorkbookOpen event; this event fires when the workbook is opened
(surprisingly enough).

Use the VBA help to get more information, or go to
http://www.mvps.org/dmcritchie/excel/event.htm for a detailed rundown
on all events, such as Worksheet_Activate which might also suit your
needs

--
juux