Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Big Brother Style Procedure
Hello!
Is it possible to make a procedure that shows a msgbox every time any Sub is executed in the active workbook? Any advice much appreciated! Thanks in advance, Albert C. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Big Brother Style Procedure
Yes. Add a message box to the beginning of each subroutine manually. It is not that hard. -- joel ------------------------------------------------------------------------ joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=147005 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Big Brother Style Procedure
The only way I know if it a brute force method. PUt a message box in every
sub. I know of no other more elegant way than that. HTH, Barb Reinhardt "Albert" wrote: Hello! Is it possible to make a procedure that shows a msgbox every time any Sub is executed in the active workbook? Any advice much appreciated! Thanks in advance, Albert C. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Big Brother Style Procedure
And if it's always the same message (or similar), you can create a new
subroutine and just call it from each of your procedures: Sub DoTheMessage(optional myStr as string = "") MsgBox "Here's a message " & myStr end sub Then you'll still have to change your existing procedures: Sub Mac1() call dothemessage("hi there") end sub or Sub Mac2() call dothemessage end sub Albert wrote: Hello! Is it possible to make a procedure that shows a msgbox every time any Sub is executed in the active workbook? Any advice much appreciated! Thanks in advance, Albert C. -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Big Brother Style Procedure
Hmmm... Yeah, I was sort of looking for the more Elegant solution, as Barb
accurately calls it. Thanks anyway... "Dave Peterson" wrote: And if it's always the same message (or similar), you can create a new subroutine and just call it from each of your procedures: Sub DoTheMessage(optional myStr as string = "") MsgBox "Here's a message " & myStr end sub Then you'll still have to change your existing procedures: Sub Mac1() call dothemessage("hi there") end sub or Sub Mac2() call dothemessage end sub Albert wrote: Hello! Is it possible to make a procedure that shows a msgbox every time any Sub is executed in the active workbook? Any advice much appreciated! Thanks in advance, Albert C. -- Dave Peterson . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Big Brother Style Procedure
You know I never see anybody use any conditional compiling statements like below #Const DebugX = False Sub test() #If DebugX = True Then MsgBox ("Test") #End If a = 1 End Sub -- joel ------------------------------------------------------------------------ joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=147005 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Big Brother Style Procedure
Perhaps if we knew why, you might get some more elegant answers. ?;^)
Nick H |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Big Brother Style Procedure
Hi Nick!
I have a few users accessing my Macro enabled workbook on a daily basis. However, i want to get an email every time they run one of the procedures. I already have the "email sender" procedure set up and working correctly I want the Big Brother to email me with the Procedure Name every time the users use any of the procedures. Thanks in advance, Albert C "Nick H" wrote: Perhaps if we knew why, you might get some more elegant answers. ?;^) Nick H . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to stop style for col A changing to style of co D date vs $ | Setting up and Configuration of Excel | |||
How do I change sheet notation from R1C1 style to A1 style in XL 2 | Setting up and Configuration of Excel | |||
Changing from format style to list style | Excel Worksheet Functions | |||
can a1 reference style and r1c1 style be used in same formula? | Excel Worksheet Functions | |||
Help my little brother | Excel Programming |