View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
L Mehl L Mehl is offline
external usenet poster
 
Posts: 73
Default Hide workbooks that drive another workbook

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