Kill Open Read Only Message on Open

D

Domenick

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]
 

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

Open my default template when right click, select New MS Word doc within a folder 0
Sub projects added as read only in Master file which are saved on sharepoint 1
Hyperlink fails to open on the first click 0
Ignore the 'file in use message' when opening Excel 3
Shortcuts in OneDrive 0
Create employee attendance db using personal.xls? 3
Remove "read-only" from Publisher file 0
Unwanted workbooks on startup 2

Top