LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Excel Template functionality without using "File-New"

Our users tend to use windows explorer to find the worksheet (often times a
template) they want to use and they double click on it to open it up. If
this is a template file, it will open up as if they are editing the template
- rather than opening up a new doc using that template -- and forcing them to
do a "SAVE-AS" and not overwrite the template file.

Is there some code/macro I can use to make it so when the user double clicks
on a template file that is ACTS AS IF they used the FILE NEW MY TEMPLATE menu
selection -- even when they directly double click on the template file?

I know this is a "training issue" but eventually one as to play the hand
they are dealt...

Denise.
 
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
Selecting "Save As" adds "Copy of" to file name- MS Excel 2007 ronhansen Excel Discussion (Misc queries) 1 November 15th 09 09:33 PM
"Document Not Saved" Saving File Created from Template PLEASEHELP!!!! Pamela[_3_] Excel Discussion (Misc queries) 1 February 5th 09 07:42 AM
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell Steve Kay Excel Discussion (Misc queries) 2 August 8th 08 01:54 AM
With autorecover on in Excel you lose your "undo" functionality. AndyBofNY Excel Discussion (Misc queries) 0 April 28th 06 10:47 AM
Utility to "clean up" or "defrag" large Excel file Sabrina Excel Discussion (Misc queries) 3 January 12th 06 09:57 PM


All times are GMT +1. The time now is 09:05 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"