Many a times you need a scenario where you don’t want user to change the worksheet name in you Excel work book.

Its quite easy to do.

Steps:

- Go to VBA Editor
- Expand your VBA Project
- Select the any Sheet

@TutorialHorizon

Many a times you need a scenario where you don’t want user to change the worksheet name in you Excel work book.

Its quite easy to do.

Steps:

- Go to VBA Editor
- Expand your VBA Project
- Select the any Sheet

This article will teach you about how you can perform a google search on Internet Explorer using Microsoft Excel.

Steps:

- Create the object of Shell Application
- Get all the windows using shellobject.Windows
- Navigate all the windows
- check if window is Internet Explorer.
- if window is IE then check if it is Google Search browser and store the object
- Get the Page object of Google Search window.
- Identify the objects on the Page using “GetElementById” and “getElementsByName”
- Put the search text
- Wait for 3-4 secs
- Click the Search button

Read moreVBA-Excel: Perform Google Search on Internet Explorer using Microsoft Excel

To **Login To Already Opened GMAIL In An Internet Explorer (IE) using Microsoft Excel**,

Steps:

- Create the object of Shell Application
- Get all the windows using shellobject.Windows
- Navigate all the windows
- check if window is Internet Explorer
- if window is IE then check if it is Gmail browser and store the object
- Get the Page object of Gmail window.
- Identify the objects on the Page using “GetElementById”
- Set the Authentication details in the Gmail login page
- Identify the Sign In Button using “GetElementById” and Click on it

Read moreVBA-Excel: Login To Already Opened GMAIL In An Internet Explorer (IE)

To **Get all the already opened Internet Explorer s(IE) using Microsoft Excel**, say for example you several IE tabs are opened and you want to get all the information like their HWND property, URLs and Title.

Steps:

- Create the object of Shell Application
- Get all the windows using shellobject.Windows
- Navigate all the windows
- check if window is Internet Explorer
- Get HWND property of Internet Explorer
- Get Title of Internet Explorer
- Get URL of Internet Explorer

**Create the object of Shell Application**

Read moreVBA-Excel: Get ALL The Opened Internet Explorer (IE) using Microsoft Excel

**Description: **The **FORMAT()** function in MS excel takes a number and returns it as formatted string based on specified parameter.

**Format:**

**VBA Function : FORMAT (number,[format])**

**Arguments:**

- Number
- Mandatory
- Type: number
- number for which the formatted string will be returned

**Description: **The **FIX()** function in MS excel returns the Integer part of a number

**NOTE: **If the number is negative, **FIX() **will return the first negative number greater than equal to the given number.

Read about Excel-VBA : INT() If the number is negative, and you want the first negative number less than equal to the given number.

**Format:**

**VBA Function : FIX (number)**

There are two different cases you might deal with,

- Lock only few specific cells and rest of the cells in the work sheet are not locked(means you can edit them)
- Lock the Enitre worksheet except few cells

**Lock only few specific cells and rest of the cells in the work sheet are not locked**

**Steps:**

- Lock the selected cells
- Provide the password

**Note:** If you wont provide the password then your cells will not be locked.

Many a times you need a scenario where you dont want user to add new worksheets in you Excel work book.

Its quite easy to do.

Steps:

- Go to VBA Editor
- Expand your VBA Project
- Double Click
**ThisWorkBook**

**Description: **The **INT()** function in MS excel returns the Integer part of a number

**NOTE: **If the number is negative, **INT() **will return the first negative number less than equal to the given number.

Read about Excel-VBA : **FIX**() If the number is negative, and you want the first negative number greater than equal to the given number.

**Format:**

**VBA Function : INT(number)**

**Excel Formula : INT(number)**

**Arguments:**

**Excel-VBA : Math Functions – VAL()**

**Description: **The **VAL** function in MS excel returns the number found in the input string

**NOTE: **This function stops reading the string when it finds first non-numeric charater. Blank spaces are not considered as non-numeric character.

**Format:**

**VBA Function : VAL(string)**

**Arguments:**

- Number
- Mandatory
- Type: String
- String from which the number needs to be extracted.

**Description: **The **SGN()/SIGN** function in MS excel returns the Sign of a number

**NOTE: **This function has different names, when used as VBA function it is SGN() and when used as Excel formula it is SIGN().

**Format:**

**As VBA Function : SGN(number)**

**As Excel Formula : SIGN(number)**

**Objective : **Suppose you have many worksheets in an excel and you want to change all the passwords in one shot rather doing it manually for every sheet, which might be very bad way to do specially when you have a power of doing it using VBA.

**NOTE**: *you need a place to store your password, most of the timewe store it in our mind but computer doesn’t have mind, it has memory :), but the point is where, it could be a file, DB . Why not use your excel for that. *

Store it in a separate sheet and make it ** very hidden** in your code.

Read moreExcel-VBA : Change Passwords for all the WorkSheets in one shot

Description:

The **ROUND** function in MS excel returns a rounded number based on the specified number of digits.

Format:

**As Excel Formula : ROUND(number,digits)**

**Note : ROUND() works slightly diffrent when used as VBA function.Click here to know about it VBA-ROUND()**

Arguments:

Description:

The **ROUND** function in MS excel returns a rounded number based on the specified number of digits.

**Note : ROUND() works slightly diffrent when used as Excel formula, Click here to know about it Formula-ROUND()**

Format:

**As VBA Function : ROUND(number, [decimal places])**

**Note : If you don’t provide the decimal places the function will consider it as 0 and returns the Integer.**

Arguments:

Description:

The **RND** function in MS excel returns the random number generated between two specified ranges.

Format:

**As VBA Function : Int((Max – Min + 1) * Rnd + Min)**

Arguments:

- Max and Min
- Mandatory
- Type: Numbers
- Random number gets generated between these two numbers (Max – the highest value the random number can be. Min – The smallest value the random number can be)

Description:

The **LOG** function in MS excel returns the logarithm of a number to the given base.

**NOTE: ***LOG function takes different parameters when it is used in WorkSheet and used as a VBA function.*

Format:

**As VBA Function : LOG( number) , default base is e = **2.71828183

**In WorkSheet : LOG( number, [base])**

Arguments:

Description:

The **EXP** function in MS excel returns the e raised to the of a number, where **e** is 2.71828183.

Where e is called Euler’s Number.

Format:

**EXP( number)**

Arguments:

- Number
- Mandatory
- Type: Number
- Number for which e power needs to be calculated

Description:

The **TAN** function in MS excel returns the tangent angle of a number.

Format:

**Tan( number)**

Arguments:

- Number
- Mandatory
- Type: Number
- Number for which tangent angle needs to be calculated

Description:

The **Sin** function in MS excel returns the sine angle of a number.

Format:

**Sin( number)**

Arguments:

- Number
- Mandatory
- Type: Number
- Number for which sine angle needs to be calculated.

Description:

The **Cos** function in MS excel returns the cosine angle of a number.

Format:

**COS****( number)**

Arguments:

- Number
- Mandatory
- Type: Number
- Number for which cosine angle needs to be calculated