accell
10-06-2014, 05:03 PM
Hey All,
The last line of my macro (that has been running smooth on PCs) brings up the save as dialog bog: 'Application.Dialogs(xlDialogSaveAs).Show'.
This command causes the macro to fail when ran on Macs. Does anyone know what the issue is or what a workaround is so that I can display the save as dialog box?
Error Reads: "Method 'Show' of object 'Dialog' failed"
Thanks!
The last line of my macro (that has been running smooth on PCs) brings up the save as dialog bog: 'Application.Dialogs(xlDialogSaveAs).Show'.
This command causes the macro to fail when ran on Macs. Does anyone know what the issue is or what a workaround is so that I can display the save as dialog box?
Error Reads: "Method 'Show' of object 'Dialog' failed"
Thanks!