Hi,
I have the following code that works perfectly on a Windows machine, but generates that compile error on a Mac.
The piece of code that blows up is ".Unprotect" in this simple loop:
The entire macro where that code snippet lies is:
Please Login or Register to view this content.
Thanks for any guidance on this!Please Login or Register to view this content.
Lawrence
Last edited by 6StringJazzer; 10-03-2019 at 01:55 PM. Reason: clarified title
I don't have a Mac so I can't test this, but how is ws declared? Is pWord longer than 15 characters? Does this fail on the first worksheet attempted, or does it successfully unprotect some sheets before it fails? (That error is a runtime error, not a compile error.)
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
Thanks for the response!
1. Dim ws As Worksheet
2. pWord (for password) is only three characters: "SMC"
3. Does it fail on the first attempt? Yes.
4. Excel's error message is "Compile error: Method or data member not found" and highlights ".Unprotect". Absolutely baffles me how such a simple loop works in Windows but fails on the Mac.
Lawrence
I don't get an error from that bit on Mac Excel 16.30 but I can tell you your workbook won't ever work properly on a Mac because you are using ActiveX controls and they aren't supported at all.
Everyone who confuses correlation and causation ends up dead.
Thanks Rorya.
The file uses forms controls option buttons. Is there ActiveX code in that macro?
Lawrence
Yes - the OLEObjects part at the end.
Ah...
Those forms are Shapes!
Would this fix it:
LawrencePlease Login or Register to view this content.
You should be able to use:
Please Login or Register to view this content.
Once again, you have saved the day.
Thank you!
Lawrence
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks