Creating a POP UP

[mrbeanyuk]

I am trying to find a qay in which I can create a pop up once a user opens an excel document stating 'do not amend this document'. is this easily done?

Thanks

 

[BBHRVS]

Welcome to the board !
See J Walkenbach methodology :
http://www.j-walk.com/ss/excel/tips/tip39.htm


I guess this is what you need.

 

[zoso]

Hi Mr Bean!

You may want to consider this option using a simple message box:

Right click tab > View Code > This Workbook >

Paste in the following code:

Private Sub Workbook_open()
MsgBox "Do NOT amend this document!", vbExclamation, "WARNING"
End Sub

Save, close and reopen to test.

HTH!

 

[mrbeanyuk]

It does not work! I tried it but nothing happens except message at open about enable macro. Click YES nothing more

 

[zoso]

OK, you need to disable macros first, close Excel and reopen again. Only disable macros if you have an AV installed - I assume you have one!

 

[tusharm]

No need for VBA. Protect the workbook with Tools | Protection > Protect workbook...

In different versions of XL the command may be located in a different menu location but it exists going way back.

I am trying to find a qay in which I can create a pop up once a user opens an excel document stating 'do not amend this document'. is this easily done?

Thanks