Prevent Sheet Being Deleted

less than 1 minute read

Title: “Worksheet event to prevent the sheet being deleted” layout: single classes: wide categories:

  • vba tags:
  • validation
  • developer
  • function date: 2019-02-06 sidebar: title: “Popular Links” nav: sidebar-sample

This prevents any worksheet from being deleted by accident using the right click –> delete method.

Pesky users!

'==========================================================================================================
' ## Prevent worksheet from being deleted without woorkbook protection
'==========================================================================================================
'// In a normal module, paste this code:
Sub UnprotectBook() ThisWorkbook.Unprotect
End Sub '// Then for every worksheet, right-click, select View Code, and then paste this:
Private Sub Worksheet_Deactivate() ThisWorkbook.Protect , True Application.OnTime Now, "UnprotectBook"
End Sub

Updated: February 06, 2019

Twitter Facebook LinkedIn

1 minute read

Here’s the simple steps to highlight the row and column of the selected cell which can be extremely useful when navigating large sets of data. Here’s a littl…

less than 1 minute read

How it Works Using SEARCH and ISNUMBER When you need to check if a cell contains specific text (or string) we need to combing the SEARCH and ISNUMBER functio…

less than 1 minute read

So you have a 0% value on one of your data labels and want to hide it?

1 minute read

Download the example workbook here: calculate-time-between-dates.xlsx

Leave a Comment