Calling a routine (XP02)

[jstevens]

In XL97 I used a private sub with the following line of code: Call Sheet3.Start

Since I switched to XP the line of code errors out.

Any suggestions?
Thanks,
John

[jstevens]

Neither. The Microsoft Excel Object named Sheet3 contains "Sub Start()". I'm trying to call or run "Sub Start()" from that object. There is a UserForm button that is clicked to call the sub-routine.

John

[shades]

Obviously "Call" is not part of the Object Library.

Are you trying to Select Sheet3 or Activate? Or is this another macro? If so, you can just use the macro name, and it will run at that point.

[shades]

Should be able to use just the name "Start" (without the quotes, although "Start" may be a inadvisable name to use for macro)

[sdckapr]

I can't test on XP ( I still use XL97), but did you try:
<pre>[Sheet3].start</pre>


Steve

[jstevens]

Steve,

Your suggestion worked but XP gave me issues along the way. I had to take the code out of the XL sheet object, paste it into a new module and then cut/paste it back to the XL object.

Yikes!!
John

John