Start a new workbook (with a single sheet).
Edit|Copy the cells in the protected form
edit|Paste special|values in the new workbook/worksheet
Save that new workbook and email it out.
Debbie wrote:
Is there a way to only save a protected form & not the background data? In
Excel, page 1 is the form w/drop downs, page 2 is the drop downs listed. If
you save the entire document it is 1 gig. We only need to save the 1st page
to forward to numerous people. Tks!
--
Dave Peterson
|