This is great Artik. I appreciate it.

As for disabling the Add-In - I thought about it. but I think it is application level, no document level.

The goal of all this story - I created a spreadsheet with plenty of pivot tables and measures (DAX measures). I sent it to tens of users. I want to prevent them form going into: power pivot --> calculate--> manage measures (they are not allowed to see the calculations).

If I disable the add-in via VBA, i would practically change their's Excel behavior for all other documents.

If there is any other way for protecting the measures I would be happy to hear. I tried to the "Protect" in the "review" tab, and this doesn't hide the measures.