View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bill Sturdevant[_2_] Bill Sturdevant[_2_] is offline
external usenet poster
 
Posts: 17
Default Looking for a way to control...

Don't know if this is the right section of the newsgroup, but...

I have a worksheet with column headers in row 1.

I want to put instructions for each column in row 2 of every column
describing what to put in the cells below (instead of using pop-up comments
in the header row).

I want to put an example in row 3 of every column.

I want to protect rows 1 through 3.

Finally, I need a way for the user to sort the entire worksheet using column
headers of their choice WITHOUT causing rows 2 and 3 to move out of place.

Any suggestions? (Macros, Buttons with VB code, etc.)