View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rob van Gelder[_4_] Rob van Gelder[_4_] is offline
external usenet poster
 
Posts: 1,236
Default Looking for a way to control...

You could create a blank row on row 4, create a duplicate column header on
row 5 (ie A5: =A1) and hide both rows 4 and 5

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Bill Sturdevant" wrote in
message ...
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.)