Thread: hide cells
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
prog prog is offline
external usenet poster
 
Posts: 7
Default hide cells

I'll try that. Also, just to let you know I'm inserting the buttons right in
the Excel spreadsheet, for this project. I'm not using a vb form or anything
like that.

"gmunro" wrote:

On Jun 5, 4:12 pm, prog wrote:
Hi,

I'm looking for some help in VBA to hide certain cells on form load. It has
been awhile since I did any vba programming, but is the form load function
Form_Load() ? Also, how do I choose individual cells to dim or hide, without
hiding the entire column or row? Thanks.


You could also try conditional formatting so that data is in white
font (assuming a white background) based on the value
Would that work?

Glen