IT-Academy

Spehovac

Aug 11th, 2016
135
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Private Sub Workbook_Open()
  2.     Dim prazdnyRiadok As Long
  3.    
  4.     ' prvy prazdny riadok
  5.    prazdnyRiadok = _
  6.     Worksheets("Špehujeme").Cells.SpecialCells(xlCellTypeLastCell).row + 1
  7.    
  8.     ' zapiseme kto
  9.    Worksheets("Špehujeme").Cells(prazdnyRiadok, 1) = Application.UserName
  10.    
  11.     ' zapiseme kedy
  12.    Worksheets("Špehujeme").Cells(prazdnyRiadok, 2) = Now
  13.    
  14.     ' tajny list skryt
  15.    Worksheets("Špehujeme").Visible = xlSheetHidden 'xlSheetveryHidden
  16.    
  17.     ' ulozit
  18.    ThisWorkbook.Save
  19.    
  20. End Sub
Advertisement
Add Comment
Please, Sign In to add comment