Are there any vba settings that control how vba corrects code imperfections? It might be that my code works on my pc but not on some other PC's because of these settings?
Are there any vba settings that control how vba corrects code imperfections? It might be that my code works on my pc but not on some other PC's because of these settings?
.
For the most part, insuring your code works on all or most computers is dependent upon your coding skills.
Excel does not have a means of "code checking" for compatibility with others systems, etc.
Two things you can do to assist you have correct coding is to use the phrase "Option Explicit" at the top of all modules. This
forces you to DIM your variables, etc. and it will check most of your coding to insure there are few errors ... but I don't
believe it can 'catch' everything.
Also, in the VBE menu, DEBUG / COMPILE VBA PROJECT .. it too will review your code for errors.
I utilize a personal website that distributes some free Excel software. Of the thousands of visitors to the site, here is a breakdown of
a few components they are using :
Screen sizes
1920 x 1080 pixels 24.2%
1366 x 768 pixels 15.2%
1024 x 768 pixels 9.1%
1600 x 900 pixels 6.1%
1680 x 1050 pixels 6.1%
1280 x 768 pixels 6.1%
1280 x 800 pixels 6.1%
1536 x 864 pixels 3.0%
1524 x 857 pixels 3.0%
1024 x 820 pixels 3.0%
OS
Windows 87.9%
MacOS 6.1%
Linux 3.0%
iOS 3.0%
Hopefully that will help some to see what others are running.
Dear Logit,
Thank you for the info. I have inserted Option Explicit and have compiled, and it found a few error which I have corrected. Tthe original issue persists, which is as follows:
I have an excel spreadsheet with VBA that works fine on my PC, however when my friend tries it on his laptop, at a certain part of the code where I start referencing the chart, it shuts his excel down without any error messages. We are both windows 10 Excel 2016. Do you think it is my code that is shutting his Excel down, or is it his PC? Regards, David
.
There may be a reference in TOOLS / REFERENCES that you have enabled and he does not ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks