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

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" <(E-Mail Removed)> wrote in message
news:6F9052DF-95F5-458A-A4ED-(E-Mail Removed)...
> 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