Need VBA Code to Detect File|Share|Email

[Steveapa]

Hi.

On workbook open event, I check Windows Login to an admin list on a sharepoint. If the user is an admin, I unprotect all visible sheets. On save event, I reprotect all sheets. But, if the admin does not save the file and does a File|Share|Email, the on_save event never occurs. This will allow an unprotected workbook to be emailed to a non admin.

How, in VBA, do I detect if the user is trying to email the file from excel so I can reportect all sheets??

Thanks.
Steve
Harrisburg, PA USA

[mongoose36]

One idea is to use Custom UI to force any users to use specific predetermined "buttons" to do what needs to be done. With a Custom UI you can all the normal options in the "File" menu, and program your own menu items with buttons for the user to click. This way you have complete control over the order of executions because when the user clicks a...shall we say..."Share this file" button it would execute a code that you create so you could simply hide the needed sheets before the code to share (which you would have to write) runs.