Not being a Mac user myself, I'll put the word out to Excel experts I know who do use Macs. I know that VBA with Macs is not as seamless a combination as with PCs, and it might be, depending on the dialog box(es) in question, that over time, Microsoft has changed the compatibility of VBA objects with Macs. If you find out anything on your own, please post back with that info, as I bet other readers would also be interested. Meanwhile, I'll be up at Microsoft in a couple weeks and will ask about this in person. If I find out anything I'll let you know.
|