AUTO_OPEN MSGBOX with button to perminently stop it

  • Thread starter Thread starter LB79
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto_open 7
Excel Is it possible to ask a question within a question? 0
More MsgBox questions. 3
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Auto_Open Code on Worksheet 2
Macro runs upon wkbk open, but no Workbook_Open or Auto_Open Macro 2
MSGBOX 1
Macro to open file bypasses Auto_Open 4

Back
Top