Tracking My Excel Sheet

How to Make my Excel Sheet send to me an E-mail when any one open it ?????

Only with VBA and what if whoever opens it does not allow VBA to run? So it's pointless.

but i hear some companies made excel sheet that any one open it it will know how come????

Where did you hear that?

i have an excel sheet from company include classified info. when i open it, it knows that
Note: the company not in my country it outside when i told my boss he said if you want to open it disconcert the internet

I won't discuss any existing workbook that may, or may not, send an email when it's opened. But if you want to send an email when a workbook is opened then the only way to do it in Excel is to use VBA. The user can simply choose not to allow VBA to run , or legitimately bypass it, so adding that functionality inside an Excel workbook is pointless.

You can monitor when a file is opened using Windows, but that's not Excel so is outside the scope of this forum.

Ever think, if you did add the email functionality, you'd be annoyed if some other boss told his employees to 'disconnect the internet' when using your workbook?

okay,how to make it by VBA please,thanks.

See this page for a comprehensive discussion on sending emails using VBA: http://www.rondebruin.nl/win/section1.htm

Use the Workbook_Open event to start the procedure.