Screen Refresh

[grahammal]

Is ther a bit of VB that I can write that will refresh the worksheet fo
me much like a normal 'Refresh' option?
I require this so that it will hide any visible drop down menu button
untill the cell that contains them is selected

 

[Dave Peterson]

Not that I know.

You could use some sort of selection change event that checks to see if there's
an object above that cell. Unhide it if there is and hide all the others.

But you may want to consider using Data|Validation. It's kind of similar to
dropdowns and comboboxes, but that's the way it works--you don't see the
dropdown arrow until the cell is selected.

 

[grahammal]

Have answered my own question.
Have used the 'Hide' & 'Unhide' commands that I use in some of my prin
outs.
ie
Rows("20:24").Hidden = True
Rows("20:24").Hidden = False
This seems to act as a refresh over the included row range.
Thanx anywa