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: Bian Nguyen   on Feb 03

One more thing...this is saved as an Excel Template which the user
will open to enter data and then it will do a number of calculations.
It is saved as VancoKinetics7.XLT. This works fine if I right click
the icon and OPEN it. However, I want them to just click the icon,
which opens a NEW file. When I do this the Sub Test() you suggested
doesn't work. It doesn't give me a Path, the Name is VancoKinetics71,
and the FullName is VancoKinetics71 (same as the name, without a
Path). Since there is no Path in the FullName, it will run no matter
where it is opened from. In Word there is difference between
Document_New and Document_Open. In Excel there is only a
Workbook_Open choice (no WorkBook_New). Does this make a difference
in how the workbook  is started (New vs Open)? If so, how do I verify
that it is only running on the specified network  path if they just
click the icon and open a NEW workbook? I don't want someone to copy
this template to, say, a flashdrive and install it somewhere else.

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: