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)

---

Puts And Removes X Mark With Double Click İn Specified Cell Ranges

Online Excel and Excel Macro (VBA) Courses

Copy Macro 'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php Option Explicit 'Belirlenen hücre aralıklarında çift tıklama ile x işareti koyar ve kaldırır Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Dim RaBereich As Range Set RaBereich = Range("B3:P16,B19:P22") If Intersect(Target, RaBereich) Is Nothing Then Exit Sub Application.EnableEvents = False Cancel = True If Target.Value = "X" Then Target.Value = "" Else Target.Value = "X" End If Application.EnableEvents = True Set RaBereich = Nothing End Sub

Report problem with this macro

This macro does not work.
There's an error in the code.
Other
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

No	Macro Name
1	puts and removes x mark with double click in specified cell ranges
2	excel operators hk
3	specifies in detail how many references the book contains (on new sheet / page)
4	Remove Text Wrap: This code will help you remove text wrap across the entire worksheet with a single click. first selects all columns and then removes the text wrap and automatically fits all rows and columns.
5	specifies in detail how many formulas are in the book (on new sheet / page)
6	Adds cells with red background color between cells A1: d20
7	list formulas on new sheet / page
8	how to remove the single quotation mark () at the beginning of the cells with the macro.
9	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.
10	calculator on / off
11	delete from listbox with double click
12	I want to throw the full cells in row with text between a1: an1000 into listbox
13	right mouse on active sheet / page menu
14	When I right click in any cell in excel, I want the "print" command to exit
15	right mouse menu on sheet / page
16	double-click to add the date and time to the comment
17	Add Quick Access to custom Lists. Add custom List Access to the Right-Click Menu
18	leads to the last row without data
19	Assign another command to the right mouse button
20	writes the names of all sheet / pages from the active sheet / page and cell and adds a link to the sheet / pages

---

---

Online Excel Courses

Online Excel Courses are here...

Click to see

Services

• Advanced Excel Courses
• Excel Macro Courses
• Comporate Valuation Courses
• Financial Mathematics
• Financial Modeling
• Comporate Valuation Services

How can we help you?

You can contact us about our services.

Contact us

Subscribe to our Youtube Channel?

Here are the videos that will make your life easier using Excel.

Subscribe Now

Keywords

Excel Videos Advanced Excel Courses Free Macros Free Excel Templates Excel Macro Courses