View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default getting current procedure name

See:

http://groups.google.com/group/micro...2af99992643b52
--
Gary''s Student - gsnu200770


"x taol" wrote:


sub test()
msgbox thisProcName
end sub

the result message 'test'

i want to make that thisProcName routine.

It must run though vbe window is closed.this is keypoint.
thus, it's not using activecodepane property...

*** Sent via Developersdex http://www.developersdex.com ***