Getting error "Type mismatch".

mbu

New member
Joined
May 3, 2015
Messages
1
Reaction score
0
Points
0
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.

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
 
Back
Top