PDA

View Full Version : Solved: Excel Templates



Paul C
06-21-2006, 02:00 AM
Hi I'm fairly new to excel, I have created a form for work which has a front menu linking to other worksheets. is there anyway i can use a macro to create a button on the front menu which will copy the current workbook and open it under a different name, basically i need to distribute the workbook to work colleges and i want other users to keep the copy i send them as a master and use the button to create a copy under a save name of there choice.

I hope i have not made that sound too confusing.


Thanks for any help, great forum by the way!

mdmackillop
06-21-2006, 05:11 AM
Hi Paul
Welcome to VBAX,
Why not save your file as a template and send that to them? Then they get a new copy each time they need it, which they can save as they please.
Regards
MD

Paul C
06-21-2006, 05:35 AM
Hi MD
works great! Had no idea you could do that, Thank you for taking the time to reply. its much appreciated

mdmackillop
06-21-2006, 07:50 AM
Glad to help.