Pop up when open excel file

[soul_krasty]

hi,

can i create a pop up when i open an excel file?

example when i open abc.xls, a msgbox appear saying "Welcome" or running some function?

[Paul]

Hi Soul_Krasty,

Quick answer: Yes, you can.

Not-so-quick answer: It depends on your workbook and who is going to use it. For safety reasons, most people have Excel prompt them to enable macros when opening a workbook (or, at least I hope they do). Once macros are enabled a pop-up can certainly appear by adding the necessary code to the 'Workbook_Open' event in the VB Editor.

For example:

Please Login or Register  to view this content.

It could obviously do a lot more than just pop-up a message, but hopefully that gets you going.

[soul_krasty]

i put it under ThisWorkbook and it work fine

thanks..