Change the format of text in disabled controls
 

Howdy,
Anyone know how to change the formatting of text in a forms control that has
been disabled so that it's not etched gray?

Thanks

Change the format of text in disabled controls
 

AFAIK cannot change that. Instead of disabling assign some property as a
flag to indicate if the macro should be aborted. The property might be
stored in a cell value or anything, perhaps some format property of the
control.

If a control property, eg caption difference, subtle colour change etc, in
the onaction macro

Dim shp As Shape
Set shp = ActiveSheet.Shapes(Application.Caller)
or
Dim obj As Object
Set obj = ActiveSheet.DrawingObjects(Application.Caller)

And read the property of the object or shape-object to determine if the
macro should be aborted.

Regards,
Peter T



Get the onaction macro to read some property
"Hokievandal" wrote in message
...
Howdy,
Anyone know how to change the formatting of text in a forms control that
has
been disabled so that it's not etched gray?

Thanks