Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/dbswav/public_html/excelwithkenan.com/goster_hazir_makrolar.php:61) in /home/dbswav/public_html/excelwithkenan.com/header.php on line 2

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/dbswav/public_html/excelwithkenan.com/goster_hazir_makrolar.php:61) in /home/dbswav/public_html/excelwithkenan.com/header.php on line 2

Excel Free Macros (VBA)


Protect All Worksheets Now: This İs A Code For You İf You Want To Protect All Your Worksheets At Once. & Nbsp; When You Run This Macro, You Will Find An İnput Box To Enter A Password. After Entering Your Password, Click All. And Be Careful With Caps.

Copy Macro





You can write your comments about the error in the box below.
Report error

ALL MACROS Youtube Channel
The following macros may be useful for you.
Similar Results
NoMacro Name
1 Protect All Worksheets Now: This is a code for you if you want to protect all your worksheets at once. & Nbsp; When you run this macro, you will find an input box to enter a password. After entering your password, click All. And be careful with CAPS.
2 excel operators hk
3 remove sheet / page protections
4 Adding Serial Numbers: This macro code will help you automatically add serial numbers to your excel sheet. After you run this macro, it will display an input box where you must enter the maximum number for serial numbers, and then add a number to the column in a column.
5 opening calculator
6 Create a Content Table: Suppose you have over 100 worksheets in your workbook. And now it is hard to navigate. Do not worry that this macro code will save everything. When you run this code, you will create a new worksheet and create a & nbsp; will create a directory.
7 Multiply All Values ​​by Number: You have a list and you want to multiply the entire number by a specific number. Just use this code. Select this range of cells and run this code. first, it will ask you the number you want to reach more than one person, and then all their numbers will be multiplied instantly.
8 Create a user-defined menu / Create your own menu and assign a macro to them in the "Extensions" section
9 Count / Highlight Cells with a Specific feature on the entire worksheet: This code will help you count the cells that have a specific value to mention, and then highlight all of those cells.
10 Codes that prevent and open the vba window and access codes
11 Add Multiple Worksheets: you can use this code if you want to add multiple worksheets in a single point in your workbook. When you run this macro code, you receive an input box to enter the total number of sheet / pages you want to enter.
12 calculator on / off
13 right mouse on active sheet / page menu
14 Find and select the remaining cell in the value between 2 selected numbers
15 Delete all but the active worksheet: This macro is useful if you want to delete all worksheets except the active worksheet. & Nbsp; When you run this macro, you can compare the name of the active worksheet with other worksheets, and then delete them.
16 Highlight Specific Text: Suppose you have a large data set and want to control a specific value. You can use this code for this. When you run, you receive an input box to enter the value to search for.
17 Add menu to file edit bar delete
18 Sort Worksheets: This code will help you sort worksheets in your workbook by name.
19 inserts months as sheet / pages Specifies days in detail
20 Convert Small Case: This code helps you convert selected text to lower case text. & Nbsp; Select a range of cells that contain your text and run this code. If a cell has any value other than a number or text, the value will remain the same.


aaaaa