VBA – Making your Excel application really cool

Some time ago I was working over an Excel file, making it look like a cool application. As far as I was getting paid for it, it had to look really outstanding 🙂

In VBA, there is a way to make your Excel file looks outstanding. The easy way is to block almost everything from view, in order to give the user the feeling that he is not in the standard Excel. Something like this:


Users are happy, that they do not see the status bar, grid lines, toolbar, scroll bars and the rest of the beauties from Excel. It really looks cool, eh? How it is achieved? Pretty much with two subs – one to deactivate all of the aforementioned at the start of the program and one to activate it back.

As simple as this 🙂 Here comes the code:

Enjoy it!

Tagged with: , ,