View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
XP XP is offline
external usenet poster
 
Posts: 389
Default Control how an Excel file is opened

Using Office 2003 and Windows XP;

Suppose I have a form designed in Excel that the user can save locally (e.g.
on their own hard drive or personal network location).

Is there any way at all to keep users from opening their saved form directly
rather than by using a custom VBScript file that opens the file for them?

For example, would it be possible to code an Auto Open in the Excel form
files that just closes the file again unless it was opened in a certain
manner or by a certain program. Could I code the VBScript loading file to
alter something in the Excel file to control this behaviour?

Reason being that there are certain things you can do with a VBScript file
that cannot be done inside Excel itself.

Thanks much for any suggetions/comments/input on this concept. Your help is
greatly appreciated.