Rob;
- Here's another approach (
http://www.excelguru.ca/node/91) for ensuring the user has macros enabled. This approach overcomes the fact that a msgbox is not shown if macros are disabled.
I had complete forgotten about this. Thanks for reminding me. I'm putting it into my template right now, so I won't forget it again.
I appreciate the advise. Where did you see a "Goto" that wasn't an "On Error Goto ..."?
I admit that I sometimes use a "Goto" in situations like this
Label1:
If Not SomeTest Then
Change Something Somewhere so that SomeTest will Pass Next Time.
Goto Label1
End If
But other than something really simple, I don't use it except in "On Erro Goto ...".
Bookmarks