View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
John John is offline
external usenet poster
 
Posts: 2,069
Default Macro to create new workbook

look at SaveCopyAs Method in VBA helpfile.
--
JB


"WLMPilot" wrote:

I have a scheduling workbook template. In this template workbook I need the
code to accomplish the following:

1) protect the template workbook so that it can never be changed,
2) code to create a new workbook via copying the template workbook.

Thanks,
Les