J
JLGWhiz
I posted this under Programming but it is not a progrmming problem so I
thought I would give the folks in this group a shot at it.
This problem is unique to one workbook that I had been using for testing
macros that I would later move to an active workbook. I have several macros
that call autoshapes such as command buttons, word art and msoShapes like
stars and explosions. I noticed that the msoShapes suddenly were not
visible. All other shapes of any type become visible as they are added to
the worksheet. It is only the msoShapes that will not appear. Here are the
conditions:
1. The msoShape object is placed on the screen but is not visible.
2. If the location is clicked, the node hanles will appear but not the
object.
3. All sheets in the workbook have the same result.
4. Only the one workbook has these symptoms.
5. Code written in the VBA module of this workbook can be moved to another
workbook and will produce visible images.
6. The same symptoms apply to manual insertion of autoshapes of the
msoShape type.
7. The shapes can be made visible by using the format > autoshape tool and
adding lines and fill.
I have checked all of the settings that I can think of, but I do not know of
one that would apply to only one workbook that could disable the msoShape
visible property.
If anyone out there knows what is causing this phenomena, I would appreciate
your advice.
thought I would give the folks in this group a shot at it.
This problem is unique to one workbook that I had been using for testing
macros that I would later move to an active workbook. I have several macros
that call autoshapes such as command buttons, word art and msoShapes like
stars and explosions. I noticed that the msoShapes suddenly were not
visible. All other shapes of any type become visible as they are added to
the worksheet. It is only the msoShapes that will not appear. Here are the
conditions:
1. The msoShape object is placed on the screen but is not visible.
2. If the location is clicked, the node hanles will appear but not the
object.
3. All sheets in the workbook have the same result.
4. Only the one workbook has these symptoms.
5. Code written in the VBA module of this workbook can be moved to another
workbook and will produce visible images.
6. The same symptoms apply to manual insertion of autoshapes of the
msoShape type.
7. The shapes can be made visible by using the format > autoshape tool and
adding lines and fill.
I have checked all of the settings that I can think of, but I do not know of
one that would apply to only one workbook that could disable the msoShape
visible property.
If anyone out there knows what is causing this phenomena, I would appreciate
your advice.