I used bits from both, and came up with a solution.
My issue was I had a role setup that I wanted to have denied a calculated member to a user group. So, I started with the first link and ran into the same error when I opened the file using a low level access domain account.
I used Adam's post, but in Step 3 I entered:
SCOPE (IIF(iserror(strtomember("Measures.[Average Test]")),|a measure no user would be denied|,Measures.[Average Test]));
if not(iserror(strtomember("Measures.[Average Test]"))) then
THIS = |WHATEVER I WANT TO CALC!|
Had a bit of redundancy, but was needed for some reason. Was finally able to shut off a calculated member for a certain access level. I was having trouble in testing because my domain user had server role access. When I logged into my computer with a lower level access I was able to open my excel report and not see the field Average Test, of which I did not want. I am now moving all my calculated members over from calculated members to named calculations.