Что делает этот проект, для чего он нужен, какие "линки" он "убивает" и можно ли обойтись без него?
Всем спасибо за внимание!
Всем спасибо за внимание!
Код |
---|
Rem Attribute VBA_ModuleType=VBADocumentModule Sub ЭтаКнига Rem Sub KillLinks() Rem On Error Resume Next Rem Dim x As Integer Rem Dim a As Integer Rem Dim c As Double Rem x = 20 Rem a = 0 Rem c = x / a Rem x = 10 Rem a = 3 Rem c = 10 / 3 Rem Rem Dim iLinks As Variant, i& Rem iLinks = ActiveWorkbook.LinkSources(xlExcelLinks) Rem If Not IsEmpty(iLinks) Then Rem For i = 1 To UBound(iLinks) Rem ActiveWorkbook.BreakLink Name:=iLinks(i), Type:=xlExcelLinks Rem Next i Rem End If Rem End Sub Rem Rem Private Sub Workbook_BeforeClose(Cancel As Boolean) Rem ActiveWorkbook.Protect Password:="Otchet2014", Structure:=True, Windows:=True Rem ActiveWorkbook.Save Rem ThisWorkbook.Saved = True Rem End Sub Rem Rem Sub vid() Rem Application.DisplayFullScreen = True Rem End Sub Rem Rem Sub vid1() Rem Application.DisplayFullScreen = False Rem End Sub Rem Rem Private Sub Workbook_SheetActivate(ByVal Sh As Object) Rem Worksheets("1Е").Range("A36").Value = Sh.Index Rem End Sub End Sub |