Register now or log in to join your professional community.
hello vaqar
Excel
go to office button > Save (a new window appear) on the left below there is option called " tools" > General option enter your password to save and modify
Auto Cad
type SECURITYOPTIONS (a new window will pop up) enter password and save the file
i hope you find this helpful good luck
Solution # 1
If you are saving excel file for the first time.
Go to file menu
Click Save button
Click tools tab
Go to general options
Enter the password, you want to open the file
or you may also enter password, you like to modify the file.
Solution # 2
If you are saving excel file for the first time.
Press Ctrl+S
Click tools tab
Go to general options
Enter the password, you want to open the file
or you may also enter password, you like to modify the file.
Solution # 3
If you are saving excel file for second time,
Press F12
Click tools tab
Go to general options
Enter the password, you want to open the file
or you may also enter password, you like to modify the file.
Solution # 4
If you are saving excel file for second time,
Go to file menu
Click Save As button
Click tools tab
Go to general options
Enter the password, you want to open the file
or you may also enter password, you like to modify the file.
open the excel file, the go to file save/save as (if it is not the first time to save it )down there is a tools button , then general options & enter the password
if You to do password at excel file we can follow those steps
we two methods.
first method -
1- from office button , choose prepare press encrypt document and put password .
the second method by VBA
start to open Developer tab start from visual basic (ALT+F)
1-insert user form
2-Insert combobox1 it's your user Name list
3-insert textbox it's your Password
4-insert check box To visible your password yes or no
5-label text and put in it caption3 "number of login" if it's correct your workbook will open if it's wrong not open
6-insert home button and double click at it and write this code
Private Sub CheckBox_Click()
If CheckBox.Value = True Then
TextBox1.PasswordChar = ""
Else
TextBox1.PasswordChar = "*"
End If
End Sub
Private Sub CommandButton1_Click()
If ComboBox1.Value = "User Name" And TextBox2.Value = "Password" Then
userform.Hide
application.Show
Else
Label3.Caption = Label3.Caption -1
If Label3.Caption =0
ThenThisWorkbook.Save
Application.Quit
End IfEnd If
End Sub
Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)Cancel = True
End Sub
must be put password at this workbook
Private Sub Workbook_Open()
Application.Visible = False
Userform.Show
End Sub
go to office button > Save (a new window appear) on the left below there is option called " tools" > General option enter your password to save and modif
