Printing switches focus off proper sheet

A

Abi

Hi there. I have a workbook with several sheets. The first sheet is a form
for data entry. At the end of the entry is a button to print. When the
printing begins, the focus of the sheet is taken off that data entry sheet
and placed on the third sheet.

(The printing prints sheet 2, and then sheets 3,4,5 in a group for page
numbering purposes.)

How do I keep the focus on the first (data entry page)? I don't want my
users having access to the other sheets.
 
R

Ron de Bruin

Hi Abi

Application.ScreenUpdating = False
Sheets(Array("Sheet1", "Sheet3")).PrintOut ' change to yours
Application.ScreenUpdating = True
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top