Running 2 Youtube Channel : The Masti Adda (Fun based ) : The Knowledge Adda (Knowledge based) : Subscribe for Knowledge with Fun....

How to show live Clock in Excel Sheet

Written by @

In this article, I am going to tell you that how you can show the current time in excel sheet.
Click on the cell where you want to display the current time and write a function as =Now ().

This function will return time and date. We need only time, so we have to change the format.

Click on the cell, where you have entered the function and Press CTRL+1. This will open a window. Under this window, Click on Custom under the Category Tab.


From given Type, you can select your required Format, as you want to show only time then select time format only.
5.       Now Right Click on Sheet Tab and click on View Code.


6.       Now go to insert tab in Visual Basic then click on the module.


Now write this code.

Sub Macro1 ()
Calculate
Application. On Time Now + Time Value (“00:00:01”), “Macro 1”
End Sub
Sub Start ()
Macro 1
End Sub


Now come to previous excel window and click on View Tab.

In View Tab, Select Macro and Click on View Macro. Now you can see the Macro 1. Click on run and your live time will be start.


After this you can get current time.



 

How to make Excel Cells Password Protected

Written by @
In working scenario, sometimes we need to make password protected file. In this article I am going to discuss how we can make excel file as password protected. Article categorized into two parts.
1. Protection of Complete file
2. Protection of some selected cells

Protection of Complete File
This is very easy task to make complete excel sheet as password protected. For this
Select your sheet (all column and rows of sheet)
After selection of complete sheet, click on Format Tab (You can also click right hand side) . When you click on Format Tab a window will be appear, now that window select protect sheet.
A Pop-window will appear, now this is time to set your password for unprotect the sheet. Uncheck the both Select locked cell and select unlocked cell. Just provide your desired password and press Ok.
Re-enter the password again and press OK. Now your sheet is password protected.