"Save" or "Save as" Only with password (?)

L

lazarovich

Board Regular
Joined
Feb 3, 2009
Messages
124
Hi,

I saw some treads with similar content but no one that I can use for my situation.

I would like to protect an excel file in the way that only users with the correct pasword (s) can "save" or "save as" the excel file.

In the case the user does not have the password or the authorized user enter an incorrect password they have the chance to ask for the correct password and then save it...otherwise the file must close without saving.

Thank you for your help.
Roberto.
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
Sort by date Sort by votes
Instead of password protecting the Save/Save As, why not restrict it on opening so that only those with the correct password can open the workbook in anything other than 'Read Only'?

HTH

Mel
 
Upvote 0
Something like this in the workbook's ThisWorkbook class module:

Code: 
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
    Const sPASSWORD As String = "MrExcel"
    
    If Application.InputBox( _
            Prompt:="Please enter the password to save", _
            Title:="Password Required", _
            Type:=3) <> sPASSWORD Then
        
        MsgBox "You entered the wrong password. File NOT saved."
        Cancel = True
    End If
    
End Sub
 
Upvote 0
Thank you Colin....Is exactly what I need.

Mel, I know it sounds crazy but I want to allow some users to see the file, interact with it BUT not left any changes saved....that´s why I need a Save or Save As password.

Regards,
Roberto.
 
Upvote 0
You must log in or register to reply here.

Similar threads

B
  • Solved
Convert all excel files in a folder to have password to modify option
Replies
6
Views
545
PeteWright
PeteWright
K
  • Question
Password Protecting Sheets by User
Replies
1
Views
213
dave3009
dave3009
R
  • Question
The VBA that I am using to password protect an excel file asks to save a copy of the file while running, when I want it to pass protect the same file
Replies
1
Views
544
Jeffrey Mahoney
Jeffrey Mahoney
K
  • Question
Lock Excel file so people are not in it when I need to edit it
Replies
2
Views
861
kevdragon1
K
M
  • Question
Excel: Security Warning Macros Disabled - only when applying Open File Password Encryption
Replies
1
Views
583
sijpie
sijpie

Forum statistics

Threads
1,214,932
Messages
6,122,332
Members
449,077
Latest member
jmsotelo

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top