Have you ever wondered & 39; may types of passwords, as the files? Is that possible? Yes. MS Excel is with five types of bulky password, which you can protect your worksheets. This means that your Excel spreadsheet guarantee with 5 other password security measures and d & 39; prevent & 39; unauthorized & 39; article worksheet.
This goals, which Users need D & 39; receive Excel worksheets for various reasons. B n fique for people in the field of finance, the MS Excel is largely by the auditors, accountants drawn, brokers, stenos and all other persons, the need for storage and display of data in an Excel structure order.
The happens types are:
1. Password to open the 2nd Archery Changes password 3 VBA Module 4 Password Worksheet-5. Password
1 issue.) Password to open the bow:
You can assign passwords to & 39; excellent work and to prevent any person, d & 39; access. To a password for your account. Xls: Open the
. Xls document that you want to protect, through a password. Select & 39; option " " Save As from the File menu " ". Click on the Tools tab " " on " & 39; top of the window " " Save As and select the option & 39 ; General Options . The application window & 39; nd & 39; shows, in which the password in the text password to open box.
If each individual tries, the unauthorized & 39; open worksheet , Microsoft Excel, you will be prompted d & 39; password. If the wrong password is not the leaf open.
2.) Password changes:
This option works the same way as the first. How the password assigned l & 39; opening of the Excel spreadsheet, the password to change the Excel worksheet can also be granted in the same way.
Open Xls this document that you protect , by a password. Select & 39; option " " Save As from the File menu " ". Click on the Tools tab " " on " & 39; top of the window " " Save As and select the option & 39 ; General Options . The application window & 39; nd & 39; shows, in which the password in the password to change to the text box.
Only authorized persons who can change the password, the document, otherwise he can not read, copy, the arc is password protected. This kind of support helps to change the document d & 39; other people, it saves the original data you have saved before you made your desk.
3.) VBA modules:
The can Excel VBA modules with adding macros in the file. This Visual Basic for Application Module can also be protected with a password. To protect password, do the following: Select the
VBA module and click on the button with the mouse. Select the VBA Project Properties option. Click on the tab protection & 39;. In this window, select the option " Lock project for visualization and & 39; by a password in the password to the Properties dialog box for the project. Click OK.
The VBA module is now protected by a password and any unauthorized use.
4.) Worksheet Password:
There can have multiple worksheets in one. Xls as sheet 1, page 2, and so on. You can password protect them. For the award of a password on any & 39; current sheet as follows:
Click on the Tools menu Protection & gt; Select " sheet. The protection of the film & 39; window. Select from the different options in your worksheet. (These options depend on the version of the work of MS Excel, I work in MS Excel 2003) After selecting the options that you can create a password for the worksheet.
5.) Issue Password:
Like Worksheets, excel notebooks can be protected , as in the protection of worksheets. Click on the Tools menu Select the protection & gt; protect SOW d & 39; option. The booklet Protect & 39; window. Select two or appropriate option for Windows and for the structure and the allocation of password.
You might try:
Click on the Tools menu " ". Select the protection & gt; protect and parts SOW option. The booklet Protect shared & 39; window. So you get a workbook with the monitoring of changes. Verify the release with an option for monitoring changes. This would d & 39; activate the password field. Assign Password password in the text box.
This type of password protection can both share the Excel worksheets. This would have the effect of restricting d & 39; other users make changes to the document, and it retains traces of change in the sheet.
As before 5 different options for the protection of the Excel spreadsheet containing passwords, it may be moments in which there is a tendency to forget or lose the password, or can exceed the document because of corrupting the attacks from viruses, accidental deletions, power outages, etc. There are a number of tools for the restoration of the word password excel to the Loss / passwords forgotten. These software tools can be easily forgotten passwords Excel files. But whether, in cases where the MS Excel file is damaged, you can try the free demo version of the kernel for resumption Excel, an Excel file recovery software that recovers slightly damaged, and repairs archery and d & 39; extracts from cells of data, formulas, charts, photos, links, etc. If the software Excel repair your data is lost, then you can use the full version of the Excel file repair software.
Visit our website: http:// Www. nucleusdatarecovery.org
Bookmark it:
Sunday, April 6, 2008
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment