Macro to create new workbook
 

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

Macro to create new workbook
 

The macro recorder is your friend

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"WLMPilot" wrote in message
...
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

Macro to create new workbook
 

Can the steps created by the recorder be assigned to a commandbutton? If
not, then I need to be able to use a commandbutton.

Thanks,
Les


"Don Guillett" wrote:

The macro recorder is your friend

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"WLMPilot" wrote in message
...
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

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

Macro to create new workbook
 

I much prefer buttons from the forms or shapes toolbars. Try it and you will
like it.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"WLMPilot" wrote in message
...
Can the steps created by the recorder be assigned to a commandbutton? If
not, then I need to be able to use a commandbutton.

Thanks,
Les


"Don Guillett" wrote:

The macro recorder is your friend

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"WLMPilot" wrote in message
...
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