So I have a workbook and it has a LAYOUT tab, where you make product selections.
Behind the scenes, the selections you make on this tab do many things: codes are built, pricing is calculated on a QUOTES tab, etc.
The selections you make on the LAYOUT tab are driven by data validation lists on a TABLES tab.
Here's my problem...
We want to send this LAYOUT tab out to customers for them to fill in. We want them to have only the table options have provided on our TABLES page.
However, we don't want to be sending out the whole file because we don't trust Excel's password security, and we don't want our customers figuring out how to get into our pricing.
What solutions can you recommend? I am trying to keep it as simple as possible, I am hoping to avoid people having to copy and paste the customer LAYOUT onto the network internal LAYOUT. In a perfect world, we wouldn't need to maintain a customer AND internal version of the file.
- Is there some kind of "extraction" program/third party option to simplify this?
- Is there a simple macro solution?
- Maybe you have experience with this type of thing and can give some advice?
Bookmarks