Disable Save As Function
Sometimes you wish to send a copy of your unfinished Excel spreadsheet only for review or for other reasons, it is logical to turn off some of its features. In this tutorial we will try to explain how to do disable the 'Save As' function of Excel using Visual Basic Applications (VBA).
How is it done
The first step is to access the Visual Basic window via Developer > Visual Basic. A new window will come out and then double click "ThisWindow" in the project browser, this will bring a blank white page at the right side where we can paste the VBA code.
Copy and paste the following code in the blank page of the VBA window.
The message can be customized as the way you like it. The code uses the built-in syntax "ByVal SaveAsUI" to call a command when the 'Save As' function were called.