VBA
11.12.2003 14:21:43
Dirk
Vielen Dank im Vorraus!
Dirk
Private Sub Workbook_BeforePrint(Cancel As Boolean)
If Worksheets("Daten").Cells(1000, 1) = 0 Then
MsgBox " CT " _
+ Chr(10) + Chr(13) + "Drucken markieren nur nur mit Registrierung möglich!" _
+ Chr(10) + Chr(13) + " Siehe Registrierung"
For Each wk In Worksheets
wk.PageSetup.PrintArea = "$AZ$1:$BA$1"
wk.DisplayPageBreaks = False
Next
End If
End Sub
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Excel.Range)
Dim x, y As Long
Dim P As String
P = Worksheets("Daten").Cells(1000, 2) + "CT2003.exe"
If FileExist(P) Then
'MsgBox "OK"
Else
MsgBox "Unberechtigter Aufruf !"
Workbooks(ActiveWorkbook.Name).Close SaveChanges:=False
Workbooks.Close
End If
If Worksheets("Daten").Cells(1000, 1) = 0 Then
x = Target.Row
y = Target.Column
Worksheets(Sh.Name).Cells(x, y).Select
End If
End Sub
Public Function FileExist(Dateiname$) As Boolean
On Error GoTo fehler:
FileExist = Dir$(Dateiname) <> ""
Exit Function
fehler:
FileExist = False
Resume Next
End Function