ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Kill Open Read Only Message on Open (https://www.excelbanter.com/excel-programming/442637-kill-open-read-only-message-open.html)

Domenick

Kill Open Read Only Message on Open
 
I have a workbook that I want to run on a schedule after working hours. It
has a Workbook_Open event that kicks off several macros. The problem is that
when Windows Scheduler opens the workbook when I'm not here, a dialog opens
stating that my personal.xls is read only. There will always be other
workbooks and instances of Excel open and who knows which one will have
read-write priveliges on personal.xls but i really don't care. How do I get
Excel to ignore this prompt for personal.xls when I open this workbook (or
any workbook for that matter)?

Thanks. [Excel 2007; Windows XP Pro]


All times are GMT +1. The time now is 08:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com