View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Wayne[_3_] Wayne[_3_] is offline
external usenet poster
 
Posts: 6
Default How To Stop Excel Copying Named Functions When A Worksheet Is Copied?

I have a workbook that contains several worksheets that have named
functions. If I copy one of these worksheets into another workbook by
right clicking the worksheet's tab and using the "Move or Copy"
functionality, all of the named functions belonging to the entire
workbook are copied into the second workbook. How can I stop Excel
copying the named functions to the new workbook?