J
jeffkeef
For some reason my department uses Excel as a form program, the higher up's
refuse to use Adobe Acrobat to make them and we end up using Excel. So I have
two questions.
1: We are attempting to have one form that will allow us to send to all
people but it needs to cover all bases: For example: I'm not from GM but just
an example.
I need to start an Excel form with a drop down that triggers other items on
the form or at leasts highlights them: Ok, the entire page would consist of
all the model cars GM makes, Chevy 1500, Chevy 2500, Cadillac CTS,Cadillac
DTS, Pontiac G6, Pontiac Vibe, Buick Lacrosse etc etc: maybe 30 vehicles.
But in the first drop-down that I make I want the user to select Pontiac or
Chevy or Cadillac or Buick and then afterwards allow those models that are
associated with that division to highlight green and the others red. This
way the person interested in Buick only see's the Buick Models highlighted
green? Is this possible with Excel or should I revert to Adobe or Word?
2: When I allow the user to print the page, can I only allow him to select
the area to print and nothing more: One page only?
refuse to use Adobe Acrobat to make them and we end up using Excel. So I have
two questions.
1: We are attempting to have one form that will allow us to send to all
people but it needs to cover all bases: For example: I'm not from GM but just
an example.
I need to start an Excel form with a drop down that triggers other items on
the form or at leasts highlights them: Ok, the entire page would consist of
all the model cars GM makes, Chevy 1500, Chevy 2500, Cadillac CTS,Cadillac
DTS, Pontiac G6, Pontiac Vibe, Buick Lacrosse etc etc: maybe 30 vehicles.
But in the first drop-down that I make I want the user to select Pontiac or
Chevy or Cadillac or Buick and then afterwards allow those models that are
associated with that division to highlight green and the others red. This
way the person interested in Buick only see's the Buick Models highlighted
green? Is this possible with Excel or should I revert to Adobe or Word?
2: When I allow the user to print the page, can I only allow him to select
the area to print and nothing more: One page only?