exclusiveaccess

  1. J

    Help in turning Alerts & Prompts off (not as easy as you think!)

    Hello, Turning prompts/alerts off and on in excel is easy with: Application.DisplayAlerts = False ' Your code Application.DisplayAlerts = True However, I am working in a shared workbook. When I want to unshare the workbook, i dont want the prompt "am i sure" bit etc. Adding the bit above, it...

Some videos you may like

This Week's Hot Topics

Top