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.

Control how an Excel file is opened
 

If you explained these "certain things", maybe someone can do it in Excel.

NickHK

"XP" wrote in message
...
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.