Change the format of text in disabled controls

[Guest]

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

 

[Peter T]

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