Appearance of Excel

[cfherd]

Hi,

I have developed a small application based in Excel that I would like to appear as if it wasn't Excel as I know you can't compile any of the program into an .exe.

What I am looking to do is first of all, when the Excel file is opened, force it to be opened in a new window and then hide all of the usual toolbars, forumula bars etc and set the overall window size so it only shows the size of my front end tab which is basically a search tool and doesn't fill the whole screen. Obviously I also want to make sure everything is restored when a user closes the file so that it doesn't affect their normal usage of Excel.

Is this possible and/or is it too risky?

Thanks
Chris

[brynbaker]

In VBE, select the sheet (in turn), and in properties (F4 if invisible) set the ScrollArea to that you want the user to see.
Record a macro that notes what you do as you try to get what you want. You'll probably not keep the macro but it documents what you do and will help describe it if you need, later in this post.
Most of the settings are worksheet specific. Don't forget tools | Options | gridlines as they are a dead giveaway.
As this is workspace specific, any other documents should not be affected. All with no macros at run time! Try it and report any specific things that fail or you can't find.