Hide Control buttons, and make worksheet fullscreen.

**abrunstad** · 05-20-2010, 06:16 PM

Hello there!

I've been Googleing around for a way to make my excel workbook do this:

Upon starting the excel file, the worksheet is maximized, control buttons are hidden, and you are not able to use the workbook as an ordinary excel file.Somewhat like a full screen flash screen, that does not go away. The cells and calculations still have to be fully operational.

I know I need to do some VBA programming, but I have NO clue, as i am a total newbie to this.

Anyone? =)

**Leith Ross** · 05-20-2010, 06:30 PM

Hello abrunstad,

I would advise against removing the Excel title bar as it contains the main menu and doing so would deprive your users of much needed functionality. Other than that caveat, yes it can be done.

**shg** · 05-20-2010, 07:30 PM

That's called a dictator application. I would respectfully suggest that if you and VBA don't already do synchronized swimming, don't jump in to that end of the pool.

**abrunstad** · 05-20-2010, 08:23 PM

Thanks guys!

**ns_k** · 08-29-2010, 01:50 PM

Originally Posted by abrunstad

Thanks guys!

Hello abrunstad!
I really need the same functionality in Excel 2010. Could you please tell if you achived that and how?
I use the following code

Please Login or Register  to view this content.

Excel goes fullscreen, controls, scrollbars are hide, but Title stays there forever (see attachment). I would really like true fullscreen without anything but my worksheet as in Excel 2003.

Thank you very much!