Message when File is opened

[sajjjid]

Whenever i open a file e.g. Shops.xlsm , I need a message to appear as "Please do not Edit this file" . Thanks.

 

[NARAYANK991]

Hi ,

This can be done using the Workbook_Open event , coding a MsgBox statement in the event procedure.

The one line required will be :

MsgBox "Please do not edit this file" , vbInformation

If you want me to code this , please upload your workbook.

Narayan

 

[sajjjid]

Why i cannot upload a file .xlsm file from here?
giving me option for .jpg and .pdf only.

 

[sajjjid]

I just drop this from explorer.

 

[Nikunj Rastogi]

It is possible only by VBA code as mention below.

Private Sub Workbook_Open()
MsgBox ("Please do not edit this file")
End Sub

 

[sajjjid]

It is possible only by VBA code as mention below.

Private Sub Workbook_Open()
MsgBox ("Please do not edit this file")
End Sub

Thanks Nikunj.
One more.
I want message to appear every 10 minutes.
E.g. Save File.