Advertisement
Guest User

Untitled

a guest
Dec 9th, 2016
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.66 KB | None | 0 0
  1. ActiveWindow.Zoom = 110
  2. ActiveWindow.Zoom = 100
  3. CommandButton3.Font.Size = 14
  4. Dim VBP As Object ' as VBProject
  5. If Val(Application.Version) >= 10 Then
  6. On Error Resume Next
  7. Set VBP = ActiveWorkbook.VBProject
  8. If Err.Number <> 0 Then
  9. MsgBox "Please enable Trust access to VBA project object model to continue"
  10. Application.CommandBars.ExecuteMso ("MacroSecurity")
  11.  
  12. ThisWorkbook.VBProject.References.AddFromGuid _
  13. GUID:="{CD000000-8B95-11D1-82DB-00C04FB1625D}", _
  14. Major:=0, Minor:=0 'Use zeroes to default to latest version
  15. 'On Error GoTo 0
  16.  
  17. Exit Sub
  18. End If
  19. End If
  20. Call Sendemail
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement