In Xcel 2013 I'm having problems reading what value is set in "Application.TransitionMenuKey".
If the forward slash ( "/") is set in File - Options - Advanced, under the Lotus Compatibility section I can add this code in my auto_open() sub and read the variable just fine in my macro. By the way, transitionvalue is dim as string.
However, If I delete the blackslash using File - Options - Advanced, under the Lotus Compatibility section then run the above code I get a "Type Mismatch" error.
What am I doing wrong?
Thanks
If the forward slash ( "/") is set in File - Options - Advanced, under the Lotus Compatibility section I can add this code in my auto_open() sub and read the variable just fine in my macro. By the way, transitionvalue is dim as string.
Code:
transitionvalue = application.TransitionMenuKey
However, If I delete the blackslash using File - Options - Advanced, under the Lotus Compatibility section then run the above code I get a "Type Mismatch" error.
What am I doing wrong?
Thanks