prevent deletion of formulated cells Free Excel Macros (VBA) | Excel Programs

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)

Prevent Deletion Of Formulated Cells

Online Excel and Excel Macro (VBA) Courses

Copy Macro

'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php 
 
Sayfanın kod bölümüne

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Dim oRange As Range
    Application.EnableEvents = False
    On Error GoTo Fehler:
    If Target.Cells.Count = 1 Then
        If Target.HasFormula Then
        MsgBox "In dieser Zelle befindet sich eine Formel oder ein Verweis." & vbLf & vbLf & "  Ein Entfernen ist nur in der Bearbeitungsleiste möglich !", vbOKOnly, "http://www.excel-lex.de.vu"
            Application.OnKey "{del}", ""
        Else
            Application.OnKey "{del}"
        End If
    Else
        Set oRange = Target.SpecialCells(xlCellTypeFormulas)
        MsgBox "Es befinden sich Formeln oder Verweise im markierten Bereich." & vbLf & vbLf & "     Ein Entfernen ist nur in der Bearbeitungsleiste möglich !", vbOKOnly, "http://www.excel-lex.de.vu"
        Application.OnKey "{del}", ""
    End If
Aufraeumen:
    Application.EnableEvents = True
    Exit Sub
Fehler:
    Application.OnKey "{del}"
    Resume Aufraeumen
End Sub

Report problem with this macro

Report error

ALL MACROS

Youtube Channel
The following macros may be useful for you.

Similar Results
No	Macro Name
1	prevent deletion of formulated cells
2	specify the number of copies to print from the printer
3	prevents sheet / page deletion & naming
4	excel operators hk
5	list formulas on new sheet / page
6	specifies in detail how many formulas are in the book (on new sheet / page)
7	and deleting formulas for formulated cells on a sheet / page as comments
8	prevent deleting formulas on the sheet / page (delete key cancel)
9	excel fonts 2
10	records detailed formatted cells on the records sheet / page
11	cancel printing in a book
12	Track and Report User Changes in an Excel worksheet or workbook
13	Undo cells with 0
14	Find and select the remaining cell in the value between 2 selected numbers
15	adding two lines and removing total
16	Adding Rows and Total Formula When Cell Changes
17	Inputbox add year as summer
18	Create your own extensions and functions in excel
19	inserts months as sheet / pages Specifies days in detail
20	protects formulated cells

Excel Free Macros (VBA)

Prevent Deletion Of Formulated Cells

Online Excel Courses

Services

How can we help you?

Subscribe to our Youtube Channel?

Keywords