AUTO_OPEN MSGBOX with button to perminently stop it

L

LB79

Im trying to create a MSGBOX in my AUTO_OPEN macro that displays
message and has the YES/NO option. If Yes is pushed the MSGBOX will po
up each time the workbook is opened, if NO is pushed the MSGBOX will no
open again.

Does anyone know a way of doing this
 
P

papou

Hello
One very simple but tricky way would be to place some value in a cell of
your workbook (1/0 or TRUE/FALSE for example) and then test this value in
your auto_open macro to choose the relevant action.

HTH
Cordially
Pascal
 
Top