Thread: protected form
View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

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