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

Don
Sat Mar 15 08:46:10 CDT 2008

The macro recorder is your friend

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com
"WLMPilot" <WLMPilot@discussions.microsoft.com> wrote in message
news:87A9C400-29F1-4EDD-BFBE-8D5893F37DE3@microsoft.com...
>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

WLMPilot
Sat Mar 15 09:32:01 CDT 2008

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
> dguillett1@austin.rr.com
> "WLMPilot" <WLMPilot@discussions.microsoft.com> wrote in message
> news:87A9C400-29F1-4EDD-BFBE-8D5893F37DE3@microsoft.com...
> >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
>
>

john
Sat Mar 15 10:25:00 CDT 2008

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

Don
Sat Mar 15 10:48:30 CDT 2008

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com
"WLMPilot" <WLMPilot@discussions.microsoft.com> wrote in message
news:78F39005-338D-435D-B19F-ED4DAF368DC6@microsoft.com...
> 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
>> dguillett1@austin.rr.com
>> "WLMPilot" <WLMPilot@discussions.microsoft.com> wrote in message
>> news:87A9C400-29F1-4EDD-BFBE-8D5893F37DE3@microsoft.com...
>> >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
>>
>>