Thread: UserForm only
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default UserForm only

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.

--
Regards,
Tom Ogilvy

"Tim" wrote in message
...
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