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.

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

NickHK

"XP" <(E-Mail Removed)> wrote in message
news12A445E-90FF-47D6-93FB-(E-Mail Removed)...
> 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.