Dear all

Since I work with a lot of learners with reading/visual e.g. tracking
difficulties, I have customised my interactive workbook with VBA so that the
view changes to "full screen" upon opening it, in order to reduce the "visual
noise" of the ribbon etc (which they can't use due to protecting the
worksheet). However, one of the functions is that there are buttons which run
macros to generate a paper-based worksheet and then open the print preview...
and when the view is still "full screen", you can no longer click on the
buttons to then print it!

Does anyone know of some code that would ensure a "normal" view when the
print preview is opened, but that would make the worksheet return to "full
screen" view when the page is printed, or "close print preview" is pressed?

I have thought about keeping just that worksheet on "normal" view (using the
worksheet activate events), but I'd still rather that the visual noise is not
there at all, even on that one sheet. I also tried adding code so that when
the button is pressed, the view returns to "normal" just before opening the
print preview. However, after printing or closing the print preview, that
worksheet is then left on "normal" view.

I also want the code to open the print preview as opposed to telling it to
print instead, in case they want to print on a printer other than their
default printer, or change print settings etc...

Any ideas would be much appreciated.

Many thanks, Neil

PS - The file returns to "normal" view upon closing it, so I'm not leaving
the learners' Excel stuck on full screen view! (some of them would not know
how to change it back)