No typo. The original macro was in Module1. When I copy
and paste it into Module3 it does not work. When I take
it back to Module1, it works. I am completely mystifed.
GMet
-----Original Message-----
Typo?
endsub
Must be
end sub
--
Regards Ron de Bruin
http://www.rondebruin.nl
"GMet" wrote in
message ...
I have a problem with a macro that calls a user form.
It
will not run in Module3. However, when I copy it to
Module1, it works just fine.
Sub ShowPiker()
Piker.show
endsub
That will not run in Module3 but it works fine in
Module1.
Anybody have a clue why this would be the case?
TIA
GMet
.