![]() |
Shadow property
Hi,
I have a workbook on which the default property of embedded drawing shapes exhibit the shadow property in some form. While I can disable the shadow property on drawing shapes, this has also affected VB controls such as buttons, text boxes, and labels. I can't seem to turn off the shadow property on these controls. When I enter VB design mode and attempt to change the shadow property from True to False, I receive an error...."Unable to set the Shadow property of the OLEObject class." I get the same error if I try from code.... sheets("sheet2").lblTimerOnOff.shadow = false. I'm looking for help in how to set the global default setting for any shapes to be "no shadow" and/or how to solve the issue on an individual control element basis. Thanks much. |
Shadow property
At some point you right clicked a shape with a shadow and selected Set
AutoShape Defaults by accident. Select a shape without a shadow and do it again. -- Jim "RLang" wrote in message ... | Hi, | I have a workbook on which the default property of embedded drawing | shapes exhibit the shadow property in some form. While I can disable the | shadow property on drawing shapes, this has also affected VB controls such as | buttons, text boxes, and labels. I can't seem to turn off the shadow | property on these controls. When I enter VB design mode and attempt to | change the shadow property from True to False, I receive an error...."Unable | to set the Shadow property of the OLEObject class." I get the same error if | I try from code.... | sheets("sheet2").lblTimerOnOff.shadow = false. I'm looking for help in how | to set the global default setting for any shapes to be "no shadow" and/or how | to solve the issue on an individual control element basis. | | Thanks much. | |
Shadow property
Thanks Jim, that did it.
"Jim Rech" wrote: At some point you right clicked a shape with a shadow and selected Set AutoShape Defaults by accident. Select a shape without a shadow and do it again. -- Jim "RLang" wrote in message ... | Hi, | I have a workbook on which the default property of embedded drawing | shapes exhibit the shadow property in some form. While I can disable the | shadow property on drawing shapes, this has also affected VB controls such as | buttons, text boxes, and labels. I can't seem to turn off the shadow | property on these controls. When I enter VB design mode and attempt to | change the shadow property from True to False, I receive an error...."Unable | to set the Shadow property of the OLEObject class." I get the same error if | I try from code.... | sheets("sheet2").lblTimerOnOff.shadow = false. I'm looking for help in how | to set the global default setting for any shapes to be "no shadow" and/or how | to solve the issue on an individual control element basis. | | Thanks much. | |
All times are GMT +1. The time now is 06:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com