-
How to show 'Save As' dialog box?
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!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules