Calling another sub is giving error

[davper]

I am trying to call this procedure from another

Please Login or Register  to view this content.

And here is how I tried to call and the resulting error:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

gives

Compile Error:
Method or Data member not found

and

Please Login or Register  to view this content.

gives

Compile Error:
Sub or Function not Defined

I can't figure it out.

Please and Thank You

[romperstomper]

Change:

Please Login or Register  to view this content.

to:

Please Login or Register  to view this content.

[davper]

Change:

Please Login or Register  to view this content.

to:

Please Login or Register  to view this content.

That does work and prevents the error. But now that procedure now appears in the list of macros that a user can run. And that is what I am tryng to prevent.

[Whizbang]

You could add a password check to the macro. That way, when the user calls the macro via the toolbar, they need to input a password for the macro to run.

Please Login or Register  to view this content.

[romperstomper]

Add:

Please Login or Register  to view this content.

to the top of the module.