To maintain confidentiality of the parameters you would need to use
Edit / Links / Break Link (or Edit / Copy; Edit / Paste Special /
Values) before sending the workbook.
If the formulas are present then the user will be able to see the value
of the parameter which came across the link.
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
|