Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pathnames to linked workbooks change from mapped drive to UNC occasionally | Links and Linking in Excel | |||
Linked network workbooks revert to pointing at my hard drive | Excel Discussion (Misc queries) | |||
how can I protect workbook on a drive from deletion | Excel Discussion (Misc queries) | |||
Link workbooks-C drive to network drive | Excel Worksheet Functions | |||
How to automaticaly hide all toolbars in in workbook when another workbooks are open? | Excel Programming |