Print preview options and full screen mode

**shirleyxls** · 01-30-2011, 05:45 PM

I'm developing an application in Excel 2007 and open the workbook in Full Screen mode.

I have 2 questions:

Can I stop the user exiting full screen mode? Obviously I will need to make this ability available to myself so that I can modify, but I wonder if there's a way I can password protect this?

I have a button on the main page for printing a report. This runs a macro which hides some sheets and prints the remaining sheets:

ActiveWorkbook.PrintOut Copies:=1, Preview:=True

However, in full screen mode, the user doesn't see the close preview or print options so they can preview the report but have to exit full screen mode to actually print it! Not ideal. Does anyone know how I can get round this, particularly bearing in mind my first question?

Any thoughts would be appreciated. Thanks

**davesexcel** · 01-30-2011, 08:09 PM

I am wondering why you need the workbook to be in full screen mode in the first place?

**shirleyxls** · 01-31-2011, 11:54 AM

Hi Dave,

The main reason I start up the app in full screen mode is to show the maximum information on the screen which is a dashboard layout. At first I just hid the ribbon by sending a ^F1 on open, but sometimes Excel would seem to ignore the Ctrl and open the help (F1) instead! I love the ribbon for working with Excel, but it takes up a lot of space on the screen when it isn't really needed. Full screen mode has the advantage of hiding all the menus (which the user doesn't need in this instance) and displaying the dashboard in a more presentation-like way.

I use password protection on the sheets anyway, so is the ribbon show/hide my only option here?

Thanks
Shirley