Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Private Sub
How do I stop "Private Subs" in "ThisWorkbook" on opening from executing.
Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Private Sub
Hi Ronbo,
I think you ned to give a little more detail. For example, when do you want to prevent execution and why? Are there any other salient factors? --- Regards, Norman "Ronbo" wrote in message ... How do I stop "Private Subs" in "ThisWorkbook" on opening from executing. Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Private Sub
"Norman Jones" wrote: Hi Ronbo, I think you ned to give a little more detail. For example, when do you want to prevent execution and why? Are there any other salient factors? --- Regards, Norman "Ronbo" wrote in message ... How do I stop "Private Subs" in "ThisWorkbook" on opening from executing. Thanks Norman 1) I loved your response. 2) I appreciated your questions. 3) I was just getting ready to update my post by adding that if you do not enable macros, you are done. Where do we go from here? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Private Sub
What exactly is the question? Your addition doesn't answer Norman's
questions IMO. The only event that fires on opening is workbook open. You cannot stop that except by disabling macros, with the effect that no macros run. If you want to stop a user from having access to your workbook if they disable macros, you cannot, but you can take some mitigating action. -- HTH ------- Bob Phillips "Ronbo" wrote in message ... "Norman Jones" wrote: Hi Ronbo, I think you ned to give a little more detail. For example, when do you want to prevent execution and why? Are there any other salient factors? --- Regards, Norman "Ronbo" wrote in message ... How do I stop "Private Subs" in "ThisWorkbook" on opening from executing. Thanks Norman 1) I loved your response. 2) I appreciated your questions. 3) I was just getting ready to update my post by adding that if you do not enable macros, you are done. Where do we go from here? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Private Sub
Bob,
That's what he said. If he disables macros it stops the code from executing. So he was saying he found the answer himself. -- Regards, Tom Ogilvy "Bob Phillips" wrote in message ... What exactly is the question? Your addition doesn't answer Norman's questions IMO. The only event that fires on opening is workbook open. You cannot stop that except by disabling macros, with the effect that no macros run. If you want to stop a user from having access to your workbook if they disable macros, you cannot, but you can take some mitigating action. -- HTH ------- Bob Phillips "Ronbo" wrote in message ... "Norman Jones" wrote: Hi Ronbo, I think you ned to give a little more detail. For example, when do you want to prevent execution and why? Are there any other salient factors? --- Regards, Norman "Ronbo" wrote in message ... How do I stop "Private Subs" in "ThisWorkbook" on opening from executing. Thanks Norman 1) I loved your response. 2) I appreciated your questions. 3) I was just getting ready to update my post by adding that if you do not enable macros, you are done. Where do we go from here? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Private Sub
Hi Tom,
I read it that way too, but he ended with .... Where do we go from here? That is where I got confused. Bob "Tom Ogilvy" wrote in message .. . Bob, That's what he said. If he disables macros it stops the code from executing. So he was saying he found the answer himself. -- Regards, Tom Ogilvy "Bob Phillips" wrote in message ... What exactly is the question? Your addition doesn't answer Norman's questions IMO. The only event that fires on opening is workbook open. You cannot stop that except by disabling macros, with the effect that no macros run. If you want to stop a user from having access to your workbook if they disable macros, you cannot, but you can take some mitigating action. -- HTH ------- Bob Phillips "Ronbo" wrote in message ... "Norman Jones" wrote: Hi Ronbo, I think you ned to give a little more detail. For example, when do you want to prevent execution and why? Are there any other salient factors? --- Regards, Norman "Ronbo" wrote in message ... How do I stop "Private Subs" in "ThisWorkbook" on opening from executing. Thanks Norman 1) I loved your response. 2) I appreciated your questions. 3) I was just getting ready to update my post by adding that if you do not enable macros, you are done. Where do we go from here? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Private Sub() - Sub() | Excel Discussion (Misc queries) | |||
Private sub problem | Excel Worksheet Functions | |||
Private sub | New Users to Excel | |||
Private subs | Excel Programming | |||
Problem with private sub | Excel Programming |