Having looked at the document - I would suggest that you use Excel instead - By using Excel, you could create the Combo boxes that you wish, and also have them invisible to printing!
- Also the lookup functions could be a lot easier as well - if you import the data upon opening (to a hidden sheet), then you could use formulas in the drop down boxes to form the values, rather than have to work with such difficult coding.
If you insert the following code into the Module in the VBA Window, then you can have it resize the document window to the user's screen size upon opening.
Code:
Sub Auto_Open()
' Prevents the screen from updating until sequence is finished
Application.ScreenUpdating = False
' Sets Sheet, Range and Cell selections:
' 'SHEETNAME = Name on sheet tab'
' 'RANGE = zoom selection' Set this to document width
' 'CELL = initial data entry cell' Set this to first data entry cell
SheetAndRangeSelection SHEETNAME, "RANGE", "CELL"
SheetAndRangeSelection wksChecklist, "A1:K4", "I7"
' Repeat the above line for each page that you wish to have resize.
Application.ScreenUpdating = True
End Sub