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