View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Excel Template functionality without using "File-New"

This isn't standard/default behavior for windows and excel--but it is a user by
user setting.

Try this first on one of the problem pc's.

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets some of the windows registry to
excel's factory defaults.

Then test it out.

If that doesn't work...

Close excel
start windows explorer
tools|folder options|file types tab
scroll down to the xlt extension
click the advanced button
click on the New item in the Actions box
click set as default
(ok your way out)

If the default action was set to Open (bold indicates default), then that could
have been the problem.

Denise wrote:

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.


--

Dave Peterson