LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,986
Default Disappearing act!

I use this code to test colors, etc. in a workbook which is for testing
purposes only.

Sub TestShp()
Dim MyDocument
Set MyDocument = Worksheets(2)
MyDocument.Shapes.AddShape msoShape32pointStar, 250, 250, 100, 200
MyDocument.Shapes(1).Fill.ForeColor.RGB = RGB(255, 100, 100)
Set newWordArt =
MyDocument.Shapes.AddTextEffect(PresetTextEffect:= msoTextEffect1,
Text:="Test", fontName:="Arial Black", fontSize:=36, FontBold:=msoFalse,
FontItalic:=msoFalse, Left:=10, Top:=10)
Counter = 0
Do
With MyDocument.Shapes(1)
.IncrementLeft Counter + 70
.IncrementTop (Counter * -1) + (-50)
.IncrementRotation 30
End With
Counter = Counter + 25
WaitTime
Loop While Counter < 100
Worksheets(2).Shapes(2).Delete
Worksheets(2).Shapes(1).Delete
End Sub

The mystery is this. The msoShape suddenly quit appearing while the WordArt
TextEffect worked just fine.

Part two of the mystery is that it only occurs in this workbook. I can copy
this code to any other workbook and it works fine.

Can this be attributed to a corrupted file or is there some other code that
I might have run that would have turned off the msoShape visible properties.
I have checked all of the code in the module and cannot find anything that
sets the visible properties to false. Does anyone have a clue?

This was previously posted without the code and no one responded.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Disappearing Data Deborah Excel Discussion (Misc queries) 1 January 23rd 09 06:01 PM
Disappearing Macros JCW Excel Discussion (Misc queries) 0 June 21st 06 09:43 PM
Disappearing text Tim Excel Discussion (Misc queries) 1 June 16th 06 05:02 PM
how do I keep a worksheet from disappearing? Jocats1 Excel Discussion (Misc queries) 0 May 5th 06 07:43 PM
Add-Ins Disappearing? Ben Excel Discussion (Misc queries) 3 July 18th 05 10:39 AM


All times are GMT +1. The time now is 05:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"