I am getting a Runtime 9 error for the below on one PC but not on another. I did notice that there are other Menus listed on the PC that continues to get errors but not on the one working properly. Any suggestions?
Please Login or Register to view this content.
Last edited by 6StringJazzer; 08-10-2017 at 04:39 PM.
Hi welcome to the forum.
How about first telling us which version of excel is being used on each machine?
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
Thank you! Both machines are running on Excel 2016.
What is the value of 'PositionOrMacro' ?
What is the strring value for 'Caption'?
Tow things
1. We cannot test since we do not have the list of pop-up menu items and my guess this is 'inherited' from code written before version 2007 appeared?
2. Have both systems set the correct reference in the VBA project? you need a vba reference for 'msoControlPopup' to work and if you set Option Explicit you get that error too if you have not set the reference
Would it be helpful if you had the whole string for that sub? And yes the code was written in I believe was 97.
I would need the file that you are testing but then you would have to make sure that the data is non-private and non-sensitive.
If it;s just about the code for the menu, you could empty the cell's contents and attach the file with with the macros included
Thank you for you continued help!
The document does have some sensitive information, and is protected let me break into it and I will get you the file.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks