Hi I am using an excel file running a vba macro. The macro code works fine on my windows pc but it doesn't work on my Mac although I have enable all macros from excel preferences.
Anyone could help??
Thank you
Anyone could help??
Thank you
First of all thank you very much for your help. My English language are basic and I am sorry if the way I wrote my answer seemed rude. I didn't have this intention in any case.There are 4 main types of module a regular module where the majority of code goes, a worksheet module (where this code should go), a Workbook module and a Class module. Please note the way this is written seems very abrupt for a legitimate question by someone who is trying to help you.
If you have transferred it from iCloud then your macro's might be blocked on the file and might have triggered the "Errors were detected while saving" message, if you transferred from a desktop with a memory stick then it is unlikely to get blocked.
Then try copying and pasting the code (preferably via a text file) from the file on the Windows machine into the Sheet code window and test (btw this answers the question I asked about which module the code is in) and test.
Then reply to this post with what issues it shows.
It is not iCloud that would block it, it would be the operating systems security (you'll get the same with Windows if you download a file containing macro's from the net or even from an email, you need to unblock it or put the file in a trusted location [you do get a warning though that the file isn't trusted below the ribbon]).it is very strange iCloud to block the code without popping any warning message
Ok. I get it. I will also try it tomorrow and I will let you know.Copy the code from your windows machine, paste it in a text file, put that on your flash drive then copy/paste that code directly into the worksheet code window on the file that is already on your Mac, obviously check that your security settings enable macro's to run then test to see if the code runs
It is not iCloud that would block it, it would be the operating systems security (you'll get the same with Windows if you download a file containing macro's from the net or even from an email, you need to unblock it or put the file in a trusted location [you do get a warning though that the file isn't trusted below the ribbon]).
I would have to test at work if Mac's behave in the same way as I transfer files at work between the 2 on a flash drive.