Hi,

I have a User Form which when displayed runs a Sub in a module, I want to
set this Sub to Private so that it doesn't show in the Run Macro window.
However, setting to Private causes the Sub to be hidden from the USer Form
and thus, the code fails. Is there a way to set the Sub to Private and
still have it run by code in a User Form.

Thanks in advance for any suggestions. Rob

Put it in the userform code module as private.



"Rob" wrote in message
...
Hi,

I have a User Form which when displayed runs a Sub in a module, I want to
set this Sub to Private so that it doesn't show in the Run Macro window.
However, setting to Private causes the Sub to be hidden from the USer Form
and thus, the code fails. Is there a way to set the Sub to Private and
still have it run by code in a User Form.

Thanks in advance for any suggestions. Rob

I had the same problem a week ago. Put this at the top of your Module. The
sub can be call from the UserForm Code Window, but it will not be seen under
Macros.

Option Private Module

Let me know if this helps

"Rob" wrote:

Hi,

I have a User Form which when displayed runs a Sub in a module, I want to
set this Sub to Private so that it doesn't show in the Run Macro window.
However, setting to Private causes the Sub to be hidden from the USer Form
and thus, the code fails. Is there a way to set the Sub to Private and
still have it run by code in a User Form.

Thanks in advance for any suggestions. Rob


.

Brian,

Solution worked a treat, Thank you. Rob

"Brian" wrote in message
...
I had the same problem a week ago. Put this at the top of your Module. The
sub can be call from the UserForm Code Window, but it will not be seen
under
Macros.

Option Private Module

Let me know if this helps

"Rob" wrote:

Hi,

I have a User Form which when displayed runs a Sub in a module, I want to
set this Sub to Private so that it doesn't show in the Run Macro window.
However, setting to Private causes the Sub to be hidden from the USer
Form
and thus, the code fails. Is there a way to set the Sub to Private and
still have it run by code in a User Form.

Thanks in advance for any suggestions. Rob


.

Thanks, the solution of putting Option Private Module before all my code did
the job.

"JLGWhiz" wrote in message
...
Put it in the userform code module as private.



"Rob" wrote in message
...
Hi,

I have a User Form which when displayed runs a Sub in a module, I want to
set this Sub to Private so that it doesn't show in the Run Macro window.
However, setting to Private causes the Sub to be hidden from the USer
Form and thus, the code fails. Is there a way to set the Sub to Private
and still have it run by code in a User Form.

Thanks in advance for any suggestions. Rob