41.

U

Ungroup command, 274

UnprotectSheets macro, 150

UserForm object

Caption property, 227-28

default event, 233

inserting, 226-27

naming, 233

overview, 233

user forms

adding check boxes, 231-33

adding command buttons, 236-38

adding option buttons, 228-30

adding text boxes, 232-33

creating user interface, 225-39

implementing, 246-52

initializing text boxes, 233-35

modal vs. nonmodal, 251

preparing functionality, 240-46

protecting user interface, 223

running from Excel, 250-52

running from Visual Basic, 250

tab order for controls, 238-39

user interface, creating, 225-39