UserForm only

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

Hello All,

I developed a worksheet with a few userforms and some
buttons. I would like the user to only use the forms and
buttons to perform any operations on the sheet. For
example, to print or save, I have buttons. The print
button sets the print area etc. For the most part, the
users are very computer illiterate, so they use only the
buttons I created. I would like to take all options,
other than my control, away from the user. Can this be
done?

Thanks for your help
 
You could lock all the cells and protect the sheet.

You need to have your code protect the sheet and set the UserInterfaceOnly
property to true so your code can still work on the sheet. See the help on
the Protect method for details.
 
You must log in or register to reply here.

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

Similar Threads

Userform to Select what worksheets to print 1
How to enumerate buttons on user form 2
Userform with option buttons to print selected sheets 3
Userform hide help 1
Userform within a userform ... 7
Simply show UserForm 5
Hidden sheet bleeds through 3
Allow text in locked cells on a worksheet from a userform 16

Back
Top