I have a database in excel (I know MS Access would be better) with
employee names, phone numbers, locker numbers etc. I have a userform
that allows me to select a specific report I want to see (ie Locker
assignment, emergency contacts etc) Is once the report is completed a
smaller user form opens up with the option to close or print the
report. Is there a way to restrict access to other sheets/options
while the report is open. I have ShowModal set to false to allow them
to scroll through the report but they can also click around to other
areas of the workbook, My intention is to force them to use the close
button on my form rather than move on to something else. Is this
possible?