Two Questions....Order Form

Hi,

I've created a form, but I need to do two things:

1. Lock certain cells: If Cell A1=Name and Cell B1 has John Doe. How
can I lock cell A1 so that it can't be modified? I'll need to do this
for all other cells too.

2. Drop Down Help:

I'm currently in cell C63, I need to add a drop down. The two optioms
need to be "Self Install" and "Systems Intergrator", "Self install" is
the defaul option.

For the default options I have hidden rows 64 to 74, but when "Systems
Intergrator" is selected I need to have these rows unhidden.

Thanking You In Advanced
Dolphy

.

Relevant Pages

  • Re: ShapeSheet Protection values not getting recalculated properl
    ... In Visio 5.0, groups were made equivalent ... then propagating the formula in a non-formatting cell ... of the Shapesheet to define a style. ... corresponding Lock properties have also been set. ...
    (microsoft.public.visio.developer)
  • Re: ShapeSheet Protection values not getting recalculated properl
    ... I would assert that if Visio is supposed to use only formatting sections to ... as a lock cell) from the style to a shape under ANY circumstances constitutes ... of the Shapesheet to define a style. ... corresponding Lock properties have also been set. ...
    (microsoft.public.visio.developer)
  • Re: How to specific the cell format?
    ... I better clarify that the formula is =TODAYand *not* the ones posted earlier. ... Sorry for the confusion. ... Since TODAYis a volatile function and it gets changed every time when the worksheet is accessed, you may want to lock in the result of the formula by doing edit>paste special>value. ... If cell A1, if text within this cell is ...
    (microsoft.public.excel.worksheet.functions)
  • Re: How to lock cell value
    ... If you do mean absolute reference & the keystroke isn't working make sure ... Hi, i cannot lock the value of a cell i Excel, the CMD+T shortcut do not work, ...
    (microsoft.public.mac.office.excel)
  • Re: Data of Sheet1 should gets autometically posted in Sheet2
    ... IF I LOCK THE CELL THEN NO ONE CAN USE FILTER OPTION. ... THUS THE NEED OF THE MACRO IS ... of the sheet and protect the sheet using tools>protection>worksheet ...
    (microsoft.public.excel.programming)