on 06-25-2015 7:42 AM
Hi,
As part of the an implementation project I have saved workbooks to SAP Netweaver Platform. We want to prevent the user to accidently save the Workbook to the SAP Netweaver Platform. Is there a way to disable the ability to save workbooks to SAP Netweaver Platform ?
Best,
Dheeraj
Hi,
you can prevent the User from saving a workbook using VBA:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Cancel = True
End Sub
The user won´t be able to save the workbook neither local nor on the server. Don´t know wether this is compatible to your requirements.
Regards,
Stephan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for the answer. I want to completely take away the ability of a user to save a version of the excel on the Netweaver or BI Platform to ensure that the excel templates always remain intact !
I do not see your recommendation helping me solve this. Correct me if I am wrong.
The drop down allows me to choose one as default and is independent of the user role or authorisation.
Any more ideas ?
Hi Dheeraj Gupta,
i searched and got below one, this is for disable insert data source, in the same way just try if that also applicable for saving
http://scn.sap.com/thread/3419735
Lets see if any other from community have any other suggestions
Subhash
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.