Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
UserForm only
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
userform | New Users to Excel | |||
Access from add_in userform to main template userform.... | Excel Programming | |||
Linking userform to userform in Excel 2003 | Excel Programming | |||
Userform inside another userform | Excel Programming | |||
UserForm | Excel Programming |