Protect Your Data

Here I'm going to learn you how you can protect your data by unexpected / unauthorized editing. Go to this Link & download example file. (This file contains all the data for my previous lessons. This lesson can follow you without downloading the file)

Open any Microsoft Excel file.

Go to review tab and Changes sub group

Click on Protect Sheet option

Then select the options you need to do after the file is protected.

Set password and Click on Ok

Try to enter or delete any data.

You can realize that it is not allowed by Excel. If you want to unprotect the sheet using the "unprotect sheet" command.

If you need to enter or update data regularly unprotecting and protecting the sheet in regular intervals may be not suitable.

Then follow below steps.

Unprotect sheet if you have already protected it.

Click on Allow Users to edit ranges command on same sub group.

Click on "New" and select the range or cell you want to enter data.

Name it in the title field.

If you want to protect this cell / range also using a password, enter the password into the "Range Password' field. (If you entered a password you have to enter it to unlock your cell to be updated)

You can enter many ranges as you wish.

After adding the fields, click on apply and close the pop up window.

Then protect the sheet using previous steps.

Now try to edit ranges you assigned.

Read Your Cells

Here I'm going to introduce you fantastic option in Excel. I would like to call this "Read Your Cells" Option. You can let excel to tell what you are typing or typed..............!. If you are wish to read my previous posts too you can download example excel sheet from here. Otherwise you don't need to download this. Let's learn how we can do this.

Open any excel file.

Click on the small arrow in the quick access toolbar and Select "More Commands".

Select "All Commands" from "choose commands from" drop down list.

Go to commands starting letter 'S'

Select and add "Speak Cells", "Speak Cells - Stop Speaking Cells" and "Speak Cells on Enter" commands.

Now you can see all commands are available on "Quick Access Toolbar"

Click on them to activate or deactivate.

Enjoy with reading excel.

Copy Macro to a Workbook

We are recording a simple macro or developing a macro to automate our tasks in excel. Sometimes we need to copy them to another workbook. Let's see how we can perform this action.

Copy The Macro. (If you copied the macro from internet or other source you can skip this section)

Go to Developer tab in the workbook which you have macro to be copied. (If you can't see developer tab, check this post 'Display Developer Tab'.) There You can see "Code" subgroup and "Visual Basic" as the first option. Click on it to open the VBA editor.

Right side of this window you can see the list of excel workbooks open at the time and list of sheets, List of forms in a workbook & list of modules in a  workbook. Find the module which is going to copy and double click on it. Now you can see the code. Select and copy all lines of the code. (Hope this module is not linked with any other module in the workbook. If you have any doubt about it, please get support from experts. Otherwise copied macro will not work properly.)

Paste the Macro

Go to Developer tab in the workbook which you have macro to be copied. (If you can't see developer tab, check this post 'Display Developer Tab') There You can see "Code" subgroup and "Visual Basic" as the first option. Click on it to open the VBA editor.

Click on insert button on the VBA editor and select 'Module'. Paste the code copied by you. Save the workbook with the macro as macro enabled workbook. (If you don't know how to check this post 'Save Your Macro'.)