I have created a spreadsheet where confidential information is entered by
managers about other managers. When a manager opens it, it is programmed to
filter out any entries about that manager by using his/her Windows login
name. This prevents them from reading entries made about themselves.

I discovered through experimentation that managers could circumvent this
filter by choosing the Advanced Filter option under the Data menu, so I
disabled it with more programming. When the user closes Excel, my programming
re-enables it.

Then I discovered that anyone could open Excel to a new workbook and add the
Advanced Filter button to an existing or new toolbar. Then, when they opened
the confidential workbook, that button is readily available to them.

Is there a way to check for the existence of the Advanced Filter button (on
any toolbar) upon opening this workbook and disabling it until they close it?
Thanks!
--
Steve C