Ugur Tuncer

Blog Archive

  • ▼  2008 (12)
    • ▼  June (12)
      • VBA Code to convert Capital Letters to Small Lette...
      • VBA Code for Self Destruct in Excel
      • VBA Code to Disable Cut, Copy and Paste Functions ...
      • VBA Code to convert small letters to upper case in...
      • Most Famous Quotes
      • Animal Farm (George Orwell) Character List
      • The Catcher in the Rye - J.D. Salinger
      • Vote for Nobody
      • Creative Match Pictures
      • Luv is all around
      • Best Movie Quotes
      • Code to Delete Blank Rows and Columns in Excel
  • ►  2007 (20)
    • ►  November (2)
    • ►  October (18)

About

View my complete profile

Wednesday, June 18, 2008

VBA Code for Self Destruct in Excel

Option Explicit

Sub KillMe()

    With ThisWorkbook

        .Saved = True

        .ChangeFileAccess Mode:=xlReadOnly

        Kill .FullName

        .Close False

    End With

End Sub

 

Posted by Ugur Tuncer at 4:52 PM

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)