cancel
Showing results for 
Search instead for 
Did you mean: 

Disable Saving Workbooks to Netweaver Platform

0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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

former_member110741
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Dheeraj Gupta,

Set your preferred platform to the one which you wanted

Subhash

0 Kudos

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 ?

former_member110741
Product and Topic Expert
Product and Topic Expert
0 Kudos

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