want to disable file save as option

[Rinki]

hi there, I have a file ( report ) in shared location which is used by multiple sales reps people keep doing changes and I am not able to figure out like who did what in this huge report. I am interested in restricting the option for save as except for myself so that I know whatever changes have happened they are because of me only.
Please suggest some macro or some settings which could help me achieve this.

 

[screach]

This can easily be done with server permissions rather than within excel. Are you using windows server or linux?

Windows try this: https://msdn.microsoft.com/en-us/library/bb727008.aspx

Linux try this: https://www.linux.com/learn/tutorials/309527-understanding-linux-file-permissions

If you give more specifics on network software I may be able to help more specifically.

 

[Jake Collins]

Dear Rinki

I think a macro as below in the Thisworkbook object achieves your desired end.

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)

If SaveAsUI Then
Cancel = True
End If
End Sub

 

[Luke M]

Side note, this topic was discussed earlier here:
http://chandoo.org/forum/threads/excel-locking-help-needed.28455/#post-171557

Posting link so other posters know what was suggested. I recommend continuing in this thread, as it's the more recent one.

 

[ThrottleWorks]

This particular problem needs coding, initially I thought suggesting 'Review' -> 'Track Changes'.