Disable/Enable File SendMail 1

[dunkyn]

I need to have users enter a password before a file can be emailed to another dept.

I have the code working for the password entry, but how do I find a workaround for them just using File Send to Mail Recipient from the main menu?

Any thoughts appreciated.

Thx.

 

[dwilson01]

This so do it.

Application.CommandBars("Worksheet Menu Bar").Controls("&File").Controls("Sen&d To").Enabled = False

 

[dunkyn]

thank you.

It looks so obvious, but sometimes it's so difficult to nail down.

I'll try it!

 

[dunkyn]

This works great...I want to give a star...

Where is it?

 

[dwilson01]

I believe it is the Mark this post as a helpful/expert post at the bottom of the post.