LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 36
Default vba addin to copy a workbook

On Feb 19, 3:46 pm, Gord Dibben <gorddibbATshawDOTca wrote:
Why don't you save the master workbook as Template. *.xlt

Make that available to users.

When user opens, it will be a copy based upon the Template, not the actual
Template.

User can save it with a unique name into a folder of their choice.

Gord Dibben MS Excel MVP


The only problem with this is that only one user can have the file
open at a time.

I don't think READ ONLY will work because a line of code in my macro
is to save. If it's read only, it busts or doesn't save.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VB addin excel can't see any workbook [email protected] Excel Programming 0 July 26th 06 03:44 PM
addin workbook afdmello Excel Discussion (Misc queries) 4 November 15th 05 04:57 PM
Cannot copy addin locally error? R Avery[_2_] Excel Programming 2 May 21st 05 03:14 AM
COM Addin doesn't link to workbook Joe Excel Programming 2 September 14th 04 06:48 PM
Copy sheet from addin jacob Excel Programming 2 April 19th 04 10:52 AM


All times are GMT +1. The time now is 06:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"