Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Matt wrote:
This is what I have Private Sub cmdExempt_Click() With ActiveCell .ClearFormats = True .Font.FontStyle = wingdings2 .Font.Bold = True .Font.Size = 20 .Validation.ErrorMessage = False .Value = "P" End With End Sub I'm getting an "Object Required" error. Thanks. ..ClearFormats doesn't need True. ..Validation.Delete should be used to eliminate a validation, not the error message. Regards, -- Beto Reply: Erase between the dot (inclusive) and the @. Responder: Borra la frase obvia y el punto previo. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Command Button Properties | Excel Discussion (Misc queries) | |||
Command Button Control Properties | Excel Discussion (Misc queries) | |||
command button properties | Excel Worksheet Functions | |||
Command Button that changes cell properties | Excel Programming | |||
Command Button Properties | Excel Programming |