Hello Group,

I have a program that exceeded the allowable amount of code. Because of this
I had to create a call to anothe Sub. All it does is do some calculation on
the worksheet, but it appears as a Sub in the list of available subs. Since
it is a Call, I would not like it to appear in the list. I would not like
anyone to try and run it independantly. Can I make it disappear from the
available list?

Thanks,
David

You can label it as
private sub mysub()

However, I'll bet your original can be reduced. You are probably using
selections etc. Post it

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"David" wrote in message
...
Hello Group,

I have a program that exceeded the allowable amount of code. Because of
this
I had to create a call to anothe Sub. All it does is do some calculation
on
the worksheet, but it appears as a Sub in the list of available subs.
Since
it is a Call, I would not like it to appear in the list. I would not like
anyone to try and run it independantly. Can I make it disappear from the
available list?

Thanks,
David

David wrote:
Hello Group,

I have a program that exceeded the allowable amount of code. Because of this
I had to create a call to anothe Sub. All it does is do some calculation on
the worksheet, but it appears as a Sub in the list of available subs. Since
it is a Call, I would not like it to appear in the list. I would not like
anyone to try and run it independantly. Can I make it disappear from the
available list?

Ignoring the fact that monolithic slabs of code like that will be a
horrible maintenance trap that will come back to haunt you.
Two easy ways to hide internal subroutines:

Declare them as "private" or give them parameters. The latter offers a
way to parameterise your problem and avoid spurious duplication of code.

Regards,
Martin Brown

Thanks Don.

That did it and I just went through another sub and reduced it by over 50%,
so you are right. It is mostly a time and effort thing.

Thanks Again,
David

"Don Guillett" wrote:


You can label it as
private sub mysub()

However, I'll bet your original can be reduced. You are probably using
selections etc. Post it

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"David" wrote in message
...
Hello Group,

I have a program that exceeded the allowable amount of code. Because of
this
I had to create a call to anothe Sub. All it does is do some calculation
on
the worksheet, but it appears as a Sub in the list of available subs.
Since
it is a Call, I would not like it to appear in the list. I would not like
anyone to try and run it independantly. Can I make it disappear from the
available list?

Thanks,
David

.