I'm trying to get past this alert. Using DisplayAlerts=False does not work.
Asked
Active
Viewed 177 times
0
-
Well it's an error message, not an alert. You have to click on it. – braX Dec 08 '20 at 01:51
-
What's the rest of your code? – BigBen Dec 08 '20 at 01:52
-
@BigBen The rest of the code is related to the function for HypExecuteMenu to refresh an essbase table in excel. – iLL-Army Dec 08 '20 at 02:07
-
@braX How do I say 'Yes' in VBA? I don't want to prompt the user for this. – iLL-Army Dec 08 '20 at 02:08
-
I could be wrong, but I don't think the Essbase/SmartView API allows for a way around this. – BigBen Dec 08 '20 at 02:12
-
Then fix the code that is causing the error. – braX Dec 08 '20 at 02:12
-
@BigBen There is supposed to be a function HypSetGlobalOption(5, 3) that will not display any error messages but it doesn't work – iLL-Army Dec 08 '20 at 02:16
-
I'd have to test it... maybe tomorrow. I've gotten the same error message before. What version of SmartView? – BigBen Dec 08 '20 at 02:18