Advertisement
Guest User

Code für die ganze Arbeitsmappe

a guest
Oct 9th, 2019
115
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. 'Code fuer die Arbeitsmappe
  2.  
  3. Option Explicit
  4.  
  5. Private Sub Workbook_NewSheet(ByVal Sh As Object)
  6.   RemoveSheetName Me, Sh
  7. End Sub
  8.  
  9. Private Sub Workbook_SheetActivate(ByVal Sh As Object)
  10.   AddSheetName Me, Sh
  11. End Sub
  12.  
  13. Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)
  14.   RemoveSheetName Me, Sh
  15. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement