Force Excel App to OPEN, disallow SAVE

[CyberJar]

Hello,

When the browser asks:
"Would you like to OPEN the file or SAVE it to your computer?"

Is there a way to force an OPEN choice? We never want the User to be able to do an explicit SAVE. of our app.

The application is an Excel Workbook executed online on a web server.

Thanks,
CyberJar

[Just Shan]

If i assume that you don't want users to enter any data and Save, Why don't you protect the sheet ? Tools | Protection


Alternatively, will this code work for you ?

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, cancel As Boolean)
cancel = True
End Sub



Paste the below code into ThisWorkbook.

How to do that ?

Open your workbook.
Press Alt + F11
See if you can find "ThisWorkbook
Double click on it and on the blank White page, paste the above code.

Best Regards,

S h a n

[CyberJar]

Hello,

I should explain further. This happens before the User has even opened my Application.

The Open/Save message is actually a File Download feature of the browser.
My Application itself does not allow Users to save on exit using the techniques you indicated above, but just selecting the app in the URL kicks off the Open/Save dialog box. (http://www.mysite.com/Book1.xls)

Is there a way to prevent this dialog box from prompting the User to Save - We want them to OPEN.

Thanks,
CyberJar

[RobDog888]

Isn't there an option in web settings or such like there is in Word
to open in browser or not? I can't find it if there is. Not in Office 2003.