Excel - lock cells based on initial click

[BobJacksonNCI]

I need to be pointed in the right direction.

Question: How can I take an initial selection in Excel and use that to trigger unlocking other cells which need to be filled in based on that initial selection?

We are using an Excel-based form to document employee changes for entry into the payroll system.
Change types include hire, transfer, promotion, insurance changes, leave of absence, sick time, vacation and separation. (One form fits all.)
As used, the form is printed and then handwritten.
We want our properties to TYPE on the forms and send them as e-mail attachments. In making this operational change, I would like to use the initial selection, new hire for example, to trigger unlocking cells that require input. If promotion was initially chosed, the cells I would want to unlock would be different than the ones for new hire.
Actually, I'm a database guy and would like a web-based database for this, but time constraints dictate doing the best I can with what we've already got.

Thanks in advance for your assistance!

HTH,
Bob

 

[SkipVought]

Hi,

You're in the wrong forum to handle this issue, because, it's gonna take some VBA coding.

Please post in VBA Visual Basic for Applications (Microsoft) Forum707.

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}

 

[Zathras]

If you don't want to go the VBA route, you could consider having a separate sheet for each type of form and one "cover" sheet with a list of links to take the user to the appropreate form.

You could also put a stack of radio buttons on the form and instruct the user to click the appropriate button and then click on the link to go the the sheet with the matching form. That would be a manual 2-step operation. If you want to do it in one step (i.e., just click the button) that would require a small amount of VBA coding.

 

[BobJacksonNCI]

Thanks to you both!

I'll repost in VBA.

Zathras, I thought about your suggestion and it would work if my Users printed the active sheet and sent it in. However, we want them to send the worksheets/books in as e-mail attachments. Having Multiple worksheets would result in my staff having to determine which worksheet contains the data to be processed.

Thanks again - Tek-Tips IS the best!
Bob