Run-time error 1004 error on Mac only Application.Get.Save.AsFilename

Good morning,

I'm a first time poster--these boards have been a lifesaver for me over the years. This one has me stumped.

I have a password-protected VBA-enabled workbook that's used by a variety of Mac and PC users. Has worked like a charm for years.

Lately a couple of Mac users have complained of an error: run-time error 1004 'MethodSaveAsFilename' of object '_Application' failed when then they try to save the file to their computers. I've encountered no issues with PC users

The code follows: debugger highlights five rows after do statement, again only on Macs--no problem on PCs.

Many thanks in advance.

Please Login or Register  to view this content.

Thank you so much for the helpful referral!