L
L Mehl
Hello --
I need help in hiding 3 workbooks while maintaining their ability to link to
and calculate for a 4th workbook.
Our sales-support application identifies hardware and prices for a
customer/user-specified system.
It consists of 4 workbooks:
Customer
Engineering
FinMktSales
FinCalculations
Each links to the other 3 to pass and retrieve information. Customer does
the data entry and results-display; the other 3 are calculators, not to be
viewed by the user.
Our plan is to
- populate Customer.xls with our best guess of starting values
- populate the other 3 with current engineering data, prices, etc., relevant
to the specific sales opportunity
- give the set of 4 to the user
We want the user to be able to test various scenarios he/she defines in
Customer.xls, where that workbook will feed the other 3 and link to and
display various calculated results to the user.
Is it possible to hide the 3 calculators and protect them from being viewed,
in away so that links still work?
Thanks for any direction on this.
Larry Mehl
I need help in hiding 3 workbooks while maintaining their ability to link to
and calculate for a 4th workbook.
Our sales-support application identifies hardware and prices for a
customer/user-specified system.
It consists of 4 workbooks:
Customer
Engineering
FinMktSales
FinCalculations
Each links to the other 3 to pass and retrieve information. Customer does
the data entry and results-display; the other 3 are calculators, not to be
viewed by the user.
Our plan is to
- populate Customer.xls with our best guess of starting values
- populate the other 3 with current engineering data, prices, etc., relevant
to the specific sales opportunity
- give the set of 4 to the user
We want the user to be able to test various scenarios he/she defines in
Customer.xls, where that workbook will feed the other 3 and link to and
display various calculated results to the user.
Is it possible to hide the 3 calculators and protect them from being viewed,
in away so that links still work?
Thanks for any direction on this.
Larry Mehl