Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Ted Collins   on Feb 03 In MS Office Category.

  
Question Answered By: Hamdan Younis   on Feb 03

you're right, it will work  if they right-click the template and
choose OPEN from the menu, as opposed to left-clicking the template
icon, which creates a NEW workbook  from the template and just opens
without having to choose from a menu (which is how people are used to
opening something). And as someone else pointed out, since the newly
created workbook has not been saved anywhere, there is no fullpath to
check against (and when I showed the message box with this info, this
was proven: the path was blank). I could instruct them to right-click
and choose OPEN instead, but then if someone does left-click, the
check will not work. And, I am trying to make this as easy as
possible. One thought I had today, and I think I have seen something
about it in the past, is there a way to change the default left-click
event from NEW to OPEN? That way someone could still just left-click,
but now it will OPEN the .XLT instead of create  NEW .XLS?

Share: 

 

This Question has 27 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Restrict workbook to network Or get search suggestion and latest updates.


Tagged: