How can I make a macro-enabled workbook look like an app?

[IanWallbridge]

Hi all,

I've built a VBA macro within a .xlsm file, but I want to make the user interface look a little more professional - at the moment, when the user opens the file they see a standard Excel blank workbook with a large 'Start' button in the middle of it (not very subtle). Is it possible to make this look much more like an app, and hide the Excel workbook entirely?

User input consists of the start button, some prompts to select a number of files, and some dialogue boxes with user choices.

This isn't something I've ever attempted before, so any guidance - even just an outline of the steps I'd need to take - would be really appreciated.

Many thanks!

 

[Swayzy]

You can hide stuff like the toolbar, formula bar etc so that the window look alot more clean. So just google excel widow properties or something like that

 

[Fluff]

Another option, you can create a UserForm which the end User will interact with & Xl itself can be hidden.
https://www.contextures.com/xlUserForm01.html