Disabling Save button (while enabling SaveAs) NO LONGER WORKS!!! (Insert cursing emoji here)

[kgartin]

What.
The.
HELL.

The code I'm using (which has been working flawlessly for years) DISABLES the save button (gives you a message to use "SAVEAS" if "SAVE" is clicked and then exits sub". When SAVEAS is clicked, it automatically saves the file with a predesignated name to a predesignated folder...or it's supposed to.

Now, no matter what happens, when the SAVE button is clicked, Excel opens the file menu and MAKES you select a filename and destination. Is this a new "feature"???

It works fine as long as you press SaveAs, but if someone clicks save, all hell breaks loose. This is the code to disable save that USED to work but now is NOT working):

If Range("AA2") <> 0 And ActiveWorkbook.Name = "PRESS REPORT1" And Not SaveAsUI Then
    Cancel = True
    MsgBox "Please use the SAVEAS option.  Report not saved."
    Exit Sub
End If

...help

 

[Jeffrey Mahoney]

You should save the file with a password to modify. People can still open it up, but they can't save over tht versio.

 

[kgartin]

You should save the file with a password to modify. People can still open it up, but they can't save over tht versio.

View attachment 107659

View attachment 107660

That interface is not familiar.

 

[Jeffrey Mahoney]

File SaveAs or Ctrl-F12
Use the Tools menu and select General Options
Add a password to "Password To Modify" (Enter it again when asked)
Don't check the "Read Only Recommend"

Users will be prompted for a password which they can ignore and open the file. They won't be able to save over the current file.

 

[kgartin]

Turns out it's an issue that occurs ONLY after double clicking a template to open. If it's not a template, or if you open a template without double-clicking, the code works perfectly.