How can I disable All prompts in Excel when a workbook opens?
For example if a user is in a Workbook and I then open same Workbook the prompt saying ReadOnly, Notify, Cancel appears. How can I get rid of that?
Printable View
How can I disable All prompts in Excel when a workbook opens?
For example if a user is in a Workbook and I then open same Workbook the prompt saying ReadOnly, Notify, Cancel appears. How can I get rid of that?
To disable prompts in Excel via VBA you can use
Application.DisplayAlerts = False
However there are some prompts that you cannot disable (I believe and I could be wrong).
This is a basic Alert which I believe cannot be disabled. And why would you want to to that?Quote:
ReadOnly, Notify, Cancel
I was wanting to disable that so that I can create my own LogIn for a Workbook, I wanted to choose who was a ReadOnly user or not as posted in this thread below.
http://www.excelforum.com/excel-prog...use-excel.html