Invalid procedure call in use of Shape property??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I get an "Invalid procedure call" error message on the 4th
line in this proc:

Private Sub butViewCmt_Click()
Dim cmt As Comment

For i = 1 To ActiveSheet.Comments.Count
Set cmt = ActiveSheet.Comments.Item(i)
cmt.Shape.AutoShapeType =
msoShapeFlowchartAlternateProc
If cmt.Visible = True Then
cmt.Visible = False
Else
cmt.Visible = True
End If
Next i

End Sub


The 4th line is: cmt.Shape.AutoShapeType

Why?

Thanks.

John Wirt
 
In Excel 2003, through Intellisense I get:

cmt.Shape.AutoShapeType = msoShapeFlowchartAlternateProcess

which is slightly different than what you had.

hth,

Doug Glancy
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code to add comments to selected cells within a selected range 30
My CommentBox is Visible Afterwards 2
Center Comment Over Selected Cell 3
Comments 4
Newby Needs minor tweak on this VBA Macro code for Excel 1
Invalid Procedure Call 6
Passing var types, groups and properties to a sub 4
Add data to comment more than one time 3

Back
Top