Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking for a way to control...
Put the instruction and example in rows 1 and 2
leave row 3 blank put column headers in row 4. Protecting protects the entire sheet, not just rows 1 to 3. Sort is disabled when a sheet is protected. -- Regards, Tom Ogilvy "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.) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Process control chart for quality control in exel? | Charts and Charting in Excel | |||
2007 Form Control/ActiveX Control font difference | Excel Discussion (Misc queries) | |||
Tool Tip Text for Form control/ Active-X control | Excel Programming | |||
Set Focus Problem for textbox control on multipage control | Excel Programming | |||
Calendar Control: Can't exit design mode because control can't be created | Excel Programming |