Excel VBA Application.Interaction

Question

I have some macro code that runs in my BeforeSave event and before it runs I am using the following line.

Application.Interactive = False

When saving the file normally everything works fine. If I select multiple tabs via ctrl/click and try to save I get an error which reads.

Run-time error '1004':
Method 'Interactive' of object '_Application' failed

It seems to me that the Interactive property is not available to set when you have multiple sheets selected. The reason I want to select several sheets and not the entire document is I am doing a save as and selecting PDF.

Any ideas why this would not work or what could be use in place of Application.Interactive?


Show source
| excel-vba   | vba   | excel   2017-01-06 00:01 0 Answers

Answers to Excel VBA Application.Interaction ( 0 )

Leave a reply to - Excel VBA Application.Interaction

◀ Go back