LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 28
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
order form Abe Excel Worksheet Functions 3 January 30th 07 02:40 AM
order form Abe Excel Discussion (Misc queries) 3 January 30th 07 02:29 AM
i want a order form lindum services Excel Discussion (Misc queries) 1 January 23rd 07 12:07 AM
Order form to BOL? jpletting New Users to Excel 3 September 12th 05 02:35 PM
Order Form Scott MacLellan Excel Discussion (Misc queries) 1 April 28th 05 01:52 PM


All times are GMT +1. The time now is 11:54 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"