on worksheet load

[Guest]

Hi,

I'm trying to dim / hide certain cells on worksheet load (in Excel). What
is the function name for On_Worksheet_Load? Also, How do I dim out certain
cells, not just columns and rows?

 

[JE McGimpsey]

You could use the

Workbook_Open()

or

Worksheet_Activate()

events, depending on your needs (worksheets don't load - workbooks do).

You can only hide entire rows or columns. However you could use the same
fill and font colors for a cell (or change its number format to ;;.
Perhaps more detail on what you're trying to do would help be more
specific.

 

[Guest]

Workbook_open() is good. Basically, what I want to do is really simple. I
have some buttons list on a spreadsheet. When I click on one button I want a
certain section of cells to unhide and then I want the user to click each
cell containing the information. Once they click on that cell that has their
info, I want that cell to highlight yellow. And then I need the changes to
persist once they send it via email. Hopefully, that explanation helps.