That was it. (I live with Medium at home and Low at work.)

hmmmm. Why would xl stop it if I already said ok to macros (with medium)?
Rhetorical question only!


Hank Scorpio wrote:

On Mon, 14 Jul 2003 19:03:57 -0500, Dave Peterson
wrote:

I may be doing something wrong, but I couldn't get it to work in xl2002
(10.4524.4219) SP-2.

Hmmm..., it looks like it's a security level thing. I just retested
it. (Same version as you.) With my security set to its usual level of
Low (this is my home machine and furrign' workbooks Are Not Allowed
Here 'Lessen' I say so, at which time I bump up the security), it runs
fine. If the level is set to either Medium or High, it won't.

Hank Scorpio wrote:

On Sat, 12 Jul 2003 12:27:39 -0400, "Tom Ogilvy"
wrote:

Just for interest, while of not much utility, you can run a sub like
Sub Tester3(sStr As String)
Debug.Print "tester3: " & sStr
End Sub

from the textbox of the Tools=Macro=Macros dialog by entering

'tester3 "Hello"'

and hitting enter or clicking the run button - but it isn't displayed in the
list.

Based on some other information on xl2002, this may not be possible there -
I haven't tested it in xl2002.

This still works in xl2002.

<<snipped

---------------------------------------------------------
Hank Scorpio
scorpionet who hates spam is at iprimus.com.au (You know what to do.)
* Please keep all replies in this Newsgroup. Thanks! *

--

Dave Peterson