Disable Save As In Excel

Mar 22, 2007

I need to disable 'save as' in an excel file. I have read some previous topics but I cant understand it. Is there anyone who can explain it to me as detailed as possible?

View 9 Replies


Disable Save And Save As Feature In VBA

Sep 5, 2012

I am trying to disable the save and save as function using a macro, i know that this in its self is quite simple but i am making VBA create a new workbook and i want this (nameless) workbook to have the save feature disabled.

View 1 Replies View Related

Disable Manual Save But Let VBA Save?

Oct 5, 2011

I need my spreadsheet to require that the user save it by clicking a macro button, and not the Save or SaveAs options in the file menu. I have found out how to disable saving entirely:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Cancel = True
If SaveAsUI Then SaveAsUI = False
End Sub

But this of course prevents my macro button from saving too!

Is there any way to allow VBA code to save the spreadsheet while simultaneously preventing the user from saving through the menu?

View 2 Replies View Related

- Disable Save As And Define The Save Name

Nov 16, 2006

I have a file that I have created that the users will use as a master template to create data that I need. Once they have finished, I want the file to define what the filename should be when they click save.

At the same time, I want to disable "Save As..." as some users will just use that and then will use a file name that another macro (that I will use) won't recognise.

View 7 Replies View Related

Disable Save & Save As Buttons

Dec 13, 2007

I use to send reports to my seniors on daily basis.
I want these reports to be with me and they can just open and check the reports, when I send them. If they try to save file through File-Save or File-Save As, they should not get these options at all in the File Menu.

View 9 Replies View Related

Disable Save As PDF Or XPS

Apr 16, 2013

Is there a way to disable 'Save as PDF or XPS' with the macro? I have tried disabling 'Save as' with the below VBA code but it does not disable 'Save as PDF or XPS'.

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
If SaveAsUI Then
MsgBox "Save As is disabled", vbInformation
Cancel = True
End If
End Sub

Also I have a macro which saves the excel report in a PDF format with 'Save as PDF or XPS' utility. I would like to enable 'Save as PDF or XPS' when this macro is started and again disable 'Save as PDF or XPS' when this macro stops.

View 1 Replies View Related

How To Disable Save Function

Jul 23, 2012

I currently have a macro which does data mining and saves the workbook in the end. I intend to disable to the save function of the workbook and force the user to use the macro everytime the workbook needs to be saved. this is what i have so far but it does not seem to work. Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)

Dim NoSave
NoSave = MsgBox("Changes have to be submitted before the workbook can be saved, Proceed and submit ?", vbYesNo, "Continue?")


View 3 Replies View Related

Disable Save As And Lock All Cells

Jul 10, 2013

I have a worksheet i want to disable

(1) save as function (if someone wants to saveas another name then it will ask for password

(2) lock all cells but unable autofilter (in my document if some one type in textbox given above it filter as typing....

My target to make it copyproof sheet and if someone copies my sheet than it is useless without password although user can only search books...

View 1 Replies View Related

Disable Save As At Program Level?

Jan 29, 2014

I know the disabling of 'Save As' has been covered alot. I have successfully disabled both Save and Save As at the file level by the following:

Making file Read Only (which disables Save option)

Inserting the following VBA to make the Save As disabled.


The remaining problem I have is disabling the Save As prompting at the program exit level.

For example, if I have a read only file with Save As disabled and I choose the workbook (file) level close window (X) button, I am prompted to save the file but am not allowed to. This is the behavior I am looking for.

HOWEVER, if I choose to exit the file by selecting the program (Excel) level close (X) button, I am prompted to save a copy of the file and it allows me to do it.

I do not want my ~180 users to have any option to save the file once it is uploaded to a centralized server location. It is a large file and I do not need multiple versions floating around.

Is it also possible to disable the 'Save As' on close at the Program level??

View 1 Replies View Related

Disable Save Except When Pressing Button Or Using Modifier?

Apr 15, 2014

I have a button in a template file, that when clicked, saves the file as a new file with file name based on data in certain cells.

I want to disable the ability to save the file with the Save icon or Ctrl-S, but the button still needs to be able to save it (the button is technically doing a Save As, so no problem there). But, I, as the administrator of the template, need to somehow be able to save updates to the template file. Can this be accomplished by coding Save to work when used with a secret key combination that only I know (I can put it in password-protected VB code)?

Then, as if that's not tricky enough, the trickier part is that once the file is saved as the new file (no longer the template) - re-enable the Save button and Ctrl-S so the user can then save it as many times as they want.

View 3 Replies View Related

Disable Save & SaveAs Menu Items

Jul 13, 2006

Is there a code or a way to make it impossible to make permanent changes to a file without first saving it as something else? I have a master report that is done monthly.

I do not want anyone to be able to save any changes on the master report. How do I go about disabling save and the save as funtions in excel? I have a save as command button that I only want people to use.

Also is there a way to set up a print command button to print to any computers default printer? I have set up a print command button on my computer and it works fine on mine, but I have sent the file to another person and the button is not doing anything on their computer. I assume because we don't have the same computers.

View 6 Replies View Related

Disable Save Query Definition Option Vba

Jan 25, 2007

I want to be able to disable the save query definition option for a worksheet using VBA. Right now I have to right click a cell and then go to Data Range Properties and then uncheck the save query definition box. If there is a way to automate this that would be great.

View 3 Replies View Related

Disable Save / Save As

Aug 8, 2009

i tried all vba's here and on google to disable save / save as, but none of them work so i would like to know the other way , how to go with clearing the contents of cell, the moment someone clicks save / save as, with /without range by using beforesave event

View 9 Replies View Related

Want To Disable Save And Save As

May 9, 2002

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, _
Cancel As Boolean)
a = MsgBox("Save Is Disabled", vbOKOnly)
If a = vbOK Then Cancel = True
End Sub

How do I get out of this file with my changes? Don't laugh.

This what I ended up with:....

View 9 Replies View Related

Disable The "Save" Option From File Menu And Allow Only To "Save As"

Sep 24, 2002

How do I disable the "Save" option from File Menu and allow only to "Save as"?
Excel 97/2000

View 9 Replies View Related

Excel 2010 :: Save Open Worksheet To File And Include Date Of Save?

Mar 11, 2014

am using Excel 2010 and having issues trying to save a worksheet to a specified file location with the save date....

I have tried several posts form this forum and elsewhere and can't seem to get the macro to do what I want.....

I want to save a 'worksheet' from an open workbook that I use for updating information to the same file path as the workbook with the date the file saved...

View 6 Replies View Related

Excel 2003 :: Unable To Allow Users To Make Changes To Workbook But Only Be Able To Do Save As Not Save

Dec 3, 2012

I have an expense report, which was originally done in Excel 2003. It still prompts users to open as read only however if they select no, they are not prompted for the password, and it has allowed them to save, so when the next person opens it, they have the previous person's report instead of the clean workbook. I have tried everything to put a password onto it. I know this is really basic stuff, but maybe I am missing a step? I want the end user to be able to make all the changes they want in read only mode and then do a save as, but if the select No when prompted "Open as Read-only?" they should have to put a password in.

View 4 Replies View Related

Excel Save As Should Default File Save Type To XLSX Using VBA

Aug 21, 2012

What I am trying to do is that I have an excel file with macros and it is a read-only file. In order for the user to save, I want them to only be able to save as a .xlsx file as it disables all macros. If for whatever reason, the user wants to save the file as another .xlsm file, they should be allowed but before they save, a "are you sure you want to save as .xlsm?" message should pop up.

All the options in the save as box should still be available in case they want to save in that particular format. Just that the .xlsx should be the default.

View 2 Replies View Related

Disable All Excel Functions?

Oct 19, 2011

Is it possible to disable all Excel functions? not as in disable calculation, but actually make Excel's standard functions not available in a workbook.

My reason for wondering if this is possible is that I would like to write UDFs that perform special actions in addition to the typical Excel functions, but give them the same name as their Excel counterparts... essentially create polymorphisms / overloaded Excel functions.

View 4 Replies View Related

Disable Excel Key-catcher

Dec 1, 2011

I'm actually trying to make a game in Excel, coded in VBS (I know, this is crazy ), and I use the API "GetAsyncKeyState" in order to catch what keys are pressed :

Public Const VK_UP = &H26
Public Const VK_DOWN = &H28
Public Const VK_LEFT = &H25
Public Const VK_RIGHT = &H27
Public Const VK_DELETE = &H2E

Set oDyn = CreateObject("DynamicWrapper")

[Code] ........

It works perfectly, except when the Excel window is activated (i.e. foreground) : GetAsyncKeyState doesn't catch keys anymore. Excel seems to keep it for himself, and don't share it with the System...

I already tried to disable the Excel DataEntryMode, but my problem's still here... Is there a way to disable this Excel's behaviour, or making GetAsyncKeyState work better ?

View 1 Replies View Related

Disable Commands Ribbon Excel

Jun 23, 2012

I have the code that accompanies the attached spreadsheet model that locks the copy, paste, cut, double click and so on, with the right mouse button and shortcut keys, however, the toolbar excel these functions still remain active. How well I block access to the toolbar.


View 14 Replies View Related

Excel 2010 :: How To Disable AutoFit

Dec 6, 2011

Every time I type a number too large for a column, Excel resizes that column. This is definitively not what I want to do. I googled a lot and looked at all options, but I could not find a way to stop this behaviour.

how to disable any Autofit initiave from Excel 2010?

View 3 Replies View Related

Disable Printing In Excel Workbook That Has 3 Worksheets?

Jul 15, 2014

I am trying to disable printing in an Excel workbook that has 3 worksheets. I do want any worksheets to be able to print.

View 2 Replies View Related

Disable Only Close Button In Excel Workbook?

May 16, 2006

Sample code on disabling the close button in Excel workbook?

I tried the Tool -> Protect -> Check Windows method. But, it will disable the maximize and minimize buttons as well. Moreover, it will minimize the workbook.

View 2 Replies View Related

Disable Copy / Paste Into Excel Workbook?

Feb 16, 2014

I Have a spreadsheet in which data is spreading into column A-Z. I would like to disable copy, paste, ^V,^R,^C, ^D for certain columns (Q-U) of the workbook so that user is forced to enter data manually on these columns.

Is there any simple of doing this using VBA.

View 2 Replies View Related

Excel 2007 :: VBA Disable Compatibility Alert

Feb 27, 2014

Currently I am working on a workbook where I am using a Save As VBA to create a folder and rename the file. The following code seems to be working fine so far with Excel 2007. Is there a way to confirm that it will work with all other versions of Excel and that my DesktopFolderPath String will work on all users machines?

In addition to these concerns, I am trying to avoid any Runtime Errors and currently, the Compatability Alert is the only thing I can see that is creating one. When it displays, in the event the user is unsure what to do, as most of our field staff is, and they select "Cancel" it displays the error Run Time Error.jpg. Can the Compatibility Alert be disabled? If so where do i add it in my code.

View 3 Replies View Related

Disable Access To Excel Backup File In VBA?

Oct 7, 2011

Is there some sort of vba code that will stop excel from creating a backup copy of the export file from access?

XLApp.ActiveWorkbook.Close SaveChanges:=True

This code saves and closes the workbook, but it then creates a backup copy. I would like to enter some code so it stops making a backup file.

View 2 Replies View Related

Excel 2010 :: Disable Something Like Text Box Related To Cells?

Aug 4, 2014

I am using excel 2010. When I click on cells on one column, something like text box will pop up with information related to that column. How can I get rid of this text box. How to disable this text box which I think it has a link between the text box and cells on that column.

View 1 Replies View Related

Excel 2003 :: Data Validation - Disable Delete Key

Mar 31, 2010

I'm using Excel 2003

Cell D7 - data validation reads as such: It is a List and the source is I6:I7. I have In-Cell dropdown selected. Ignore Blank is not checked.

I now password protect the sheet and only D7 is unlocked. real simple, the person using it can only use D7 and select one of two in the drop down menu.

The problem is, if the user clicks on D7 and hits delete, the cell goes blank. How can I avoid this?

View 8 Replies View Related

Excel 2007 :: Disable Insert Columns / Rows Only

Mar 1, 2012

I am looking for a way of allowing users to edit the existing cells at their will, but simultaneously disabling the option to insert/ delete columns or rows.

By enabling Sheet Protection, I cannot find a way to do it. Can I?

I am on MS Excel 2007 by the way.

I found the way, just unlock all cells in Format Cells, Protection Tab. Then Protect sheet and de-select what you want to disable.

View 1 Replies View Related

Copyrights 2005-15 www.BigResource.com, All rights reserved