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'.)