Great !!!! Thanks for the help.
JLGWhiz wrote:
You had too much in the statement. Try this.
ActiveSheet.OLEObjects("CommandButton1").Object _
.Caption = "Track Selected Cell"
I have a spreadsheet that goes through some data and organizes it into two
other sheets within the same workbook. The original sheet is left as is
[quoted text clipped - 39 lines]
Several other options have been tried to no avail. Most of the time I get an
error that says "Object doesn't support this property or method.".
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200807/1