View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.setup
bjf144 bjf144 is offline
external usenet poster
 
Posts: 1
Default Can you mail merge information from protected Excel sheet?

I have a protected spreadsheet that is 95% locked. The 5% that is not locked
consists of user input fields and the remainder of the spreadsheet calculates
answers. I want to mail merge the answers from the formulas onto labels, but
these are the locked fields. The locked fields are not available when I
select the Excel spreadsheet fields. Is there a way to get the data from a
protected spreadsheet?