View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Roundy Roundy is offline
external usenet poster
 
Posts: 15
Default copy sheets with values only and NO link to old workbook

I am trying to create a copy of two sheets from a large workbook and bring
only the values over for cells and for some text boxes. I also want to
create the copy without ANY linking between workbook. I ran this code on the
new sheet, but it doesn't do anything about the link or the text boxes that
reference name ranges.