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]
-1
Utf
5/18/2010 7:11:01 PM
excel.programming 6508 articles. 2 followers. Follow

0 Replies
1031 Views

Similar Articles

[PageSpeed] 24

Reply:

Similar Artilces:

Conditional Opening of Excel file
Hi, I have a complex workbook that relies on various SUMIF's from othe reference workbooks. If these aren't open, then obviously the formula don't work. As it's for someone else; I want a piece of VB so that when they *open the main workbook, it checks to see if the ref file is open, and i not, it automatically opens it for them. A bit like this sub worksheetopen '(Not sure where this should go in parent book) if workbook("Referencefile.xls") is NOT open then workbook("referencefile.xls").open endif endsub Any ideas folks?:confused -- Message p...

Trouble opening publisher docs from CD
I burned a CD containing publisher documents (all were changed from read only)for a associate to use. However, when the associate put in the CD, he could open the documents, but could NOT make any changes or additions. A box comes up stating something about "hidden" atributes or something like that. He also copied the entire folder into his computer and still couldn't make any changes or additions to the individual documents. What are we doing wrong. I appreciate any help to resolve this problem and thank anyone who may have the answer. Once those publications ar...

Email Messages disappearing
I have my email (Microsoft Outlook on Microsoft XP) set up to go to specific folders dependent on who sends it. Well, there are messages unread in certain folders it will have a number next to it. Well, I'll click on the folder and the number changes. Not one number but multiple. Like it says there are 5 messages in the folder unread, I'll click on it and then it says one and the other 4 messages are missing. I don't know what is causing this. Rachel rachel <rachel@discussions.microsoft.com> wrote: > I have my email (Microsoft Outlook on Microsoft XP) set up t...

Why is Publisher printing very light, hard to read, after reinstal
I had to reload my Microsoft Office 2000 and now the print on my Publisher documents is very light and hard to read. How do I change this to a darker look? Betty FLorida This is not a Publisher issue. Do you have your printer set to draft? Is your driver current? Clean your printer heads. -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "Betty Florida" <Betty Florida@discussions.microsoft.com> wrote in message news:331DD522-35D0-4448-9DA8-744A74476E25@microsoft.com... >I had to reload my Microsoft Office 2000 an...

Excel cannot open email program.
I often use "file.. send to... mail recipient" to send a spreadsheet as text in the body of an e-mail. I prefer that to sending excel as an attachment, since my recipients may not have excel and usually don't need to see formulas. On my new computer however I get the message "excel could not open the e-mail program" if I try the first option above. Both excel 2002 and outlook 2002 are working fine. I "repaired" office just to be sure. Still doesn't work. Only difference is that the computer came with a trial version of office 2003 which I don...

Outlok 2003 Word Attachments are Read Only and in 2 page view
I have a client with Outlook 2003 and when he receives an email with a word doc attached and attempts to open it (rather than save it 1st) it opens in Word as read only and shows as a split screen (2 page book view). if he saves it to the drive 1st he can remove the read only attribute and then Word opens it normally. Any Ideas? Not sure why the view is different. My OT advice - always save attachments you want to edit, and then open them. Otherwise you're using a temp copy of the file & may lose changes. Marc Seidler wrote: > I have a client with Outlook 2003 and when he recei...

Open XML File Converter
Version: 2004 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Any word on an update to this converter that resolves the "There is not enough memory or disk space to convert this document" bug on SL? I've seen it reported elsewhere so I'm assuming it's a known issue, but can't find any relevant info here. Thanks. On 11/2/09 2:33 PM, in article 59b7fd3a.-1@webcrossing.caR9absDaxw, "elliotcolbert@officeformac.com" <elliotcolbert@officeformac.com> wrote: > Any word on an update to this converter that resolves the "There is not e...

manual Control Messages in MFC
I m sure someone done this before my CFormView derived class has a few checkboxes. I want to force the message handlers of all the checkboxes to be called when I change (check/uncheck) one of them. I dont want to use the group thing. my code is like this CMyFormView::OnCheck1() { m_bStatusCode = ((CButton *)(GetDlgItem( IDC_CHECK_COMPILE_CODE )))->GetCheck() ? TRUE : FALSE; m_MyGUI = COMPILE_CODE; /* needs to send the notify the parent to execute the other message handlers*/ } CMyFormView::OnCheck2() { m_bStatusAssets = ((CButton *)(GetDlgItem( IDC_CHECK_BUILD_ASSETS )))->GetCh...

unable to open CRM web page
It seems that I can open the CRM web page from the server but not from any workstations. It also affected any clients that were using the Outlook client. I have tried opening the page using the ip address, and the FQDN of the the server and still didn't have any luck. Someone point me in the right direction. Hi Flip, Well a few things to try to narrow the problem down: 1. Can you ping the server with the IP address / FQDN? 2. Can you log into the server with a non administrator and get to the site locally? (may be a permission issue, set to run as local or network service) 3. Log...

Font size changes in Excel 2003 charts when re-opened
For certain charts that I create within Excel 2003 (usually bar charts), I use a font size of 8 (eg for data labels, axis labels, and scale). If I close the file and then re-open it, all these fonts will have become size one (title and legend are not effected). Oddly, if I have created a bar chart and made several copies of it within a worksheet, it will only be the original and not the copies that are affected by this. If anyone can shed any light on why this may be happening and how it could be fixed, I would really appreciate it. Lucie ...

Exchange POP3 Message Retrieval WOES..........
Is there any possible way to decrease the amount of time for Exchange to go out and check a mail server in the POP3 settings? It will not go any lower than 15 minutes before Exchange will even attempt to go out and look for mail. For people that live and die by e-mail everyday, you would think that you could set it down to every minute if we so choose. Why limit it to only 15 minutes. Is there a VB script that will run that process faster or tell Exchange to go check for mail now versus having it wait 15 min? BTW, this is with SBS 2003 Standard Edition Please help, this is a major ...

open multiple workbooks at startup
Ever since i ran a macro that opened several workbooks, my Excel always opens the same workbooks. I have searched and deleted all the files that are being opened. Search shows they are in a sub-folder "Application Data", but this folder is not listed in explorer and the files that are opened are not found with a file search. another thing, the open files in Excel options is cleared to blank. How do I stop opening these files when I open another file? Dear Ron, you can find the folder application data if you switch on the view hidden files option in windows it will be in C:...

Importing messages from Outlook 2003 into 2000?
I have Outlook 2003 on my computer at work and Outlook 2000 on my computer at home. I would like to move some messages from my work to my home machine. Unfortunately, Outlook 2000 doesn't seem able to understand the .pst files generated by Outlook 2003. Is there any way around this? Colin Make sure you create and copy items into a legacy (Outlook 97 - 2002) pst file. See File | New | Outlook Data file. Pick the Outlook 97 - 2002 type. Copy items form mailbox to this new pst. Close it when done (right click on personal folders and select close/disconnect.) "Colin Caulkins&...

Visual Basic Error Message #2
After updating an application unrelated to Excel that I have been using for two years, evefry time I now start Excel (I'm using Excel 2003, by the way), I initially get a Microsoft Visual Basic error window popping up on my screen: "System Error &H8000FFFF (-2147418113). Catastrophic failure." When I click OK, a second Microsoft Visual Basic error window pops up: "Out of memory." I then click OK, the window disapears, and then everything runs just fine. All my calculations, prior work and spreadsheets and so forth, as well as new files I create are readily...

news/outlook bar, opens a folder rather than news?
Just happened today. I have newsgouprs in my OL 2003 bar, when I click on it opens a folder C:\Program Files\Common Files\SYSTEM\MSMAPI\1033 rather than my news, suggestions on how to remedy this? thanks Think I have it fixed, thanks "Bruce Leavitt" <Notthis1@noidea.com> wrote in message news:O$BkIGB9IHA.2336@TK2MSFTNGP03.phx.gbl... > Just happened today. > I have newsgouprs in my OL 2003 bar, > when I click on it opens a folder C:\Program Files\Common > Files\SYSTEM\MSMAPI\1033 > > rather than my news, suggestions on how to remedy this? > thanks ...

Error openning Workbook
I am having trouble openning an Excell 2002 workbook. The file is 49 meg in size and I am running Win 2000 OS. The error message provided has no value. just stated whether to send error report to Microsoft. Thanks ...

M00
Hi, all When I update stock prices from the Internet, I get two messages: Component Update: The Internet, banking or brokerage server could not process the request. Please try your call later. (SMC) Money was unable to retrieve currency exchange rates for Euro... The stock prices seem to update correctly. Does anyone have any idea how to get rid of these messages? Cheers - rick ...

First Time Opening Outlook
I just installed Outlook and when I try to open it, I get a popup message titled "Connecting to Microsoft Exhange Server". The message is, "Your Microsoft Exchange Server is unavailable." and a second popup says, "Configuring Outlook Accounts". The configuation process never does complete. I can even open outlook. Help! Thanks Ross Ross <Ross@discussions.microsoft.com> wrote: > I just installed Outlook and when I try to open it, I get a popup > message titled "Connecting to Microsoft Exhange Server". The message > is, "You...

Visual Studio can't open resource file in Resource View after IDE crash
Hello, I have a strange problem with Visual Studio .NET 2003, I hope that this is the appropriate newsgroup. After adding an icon resource to my project, Visual Studio crashed, and after restarting it, it was unable to open my project's resource file in the resource view pane. It displays the name of the rc file, but when I click the "+" beside it to open the resources, nothing happens, and the "+" disappears. There is no error message. Restarting Visual Studio and rebuilding my project didn't help. I can open all other projects' resource files without problem...

When collecting data by using e-mail messages
I'm getting the Warning message - these email messages might contain data that is of a confidential or sensitive nature - and it's not giving me access to the Create button in the wizard. The suggestion is to remove any fields in my message that might contain the confidential data, but there are none. How do I get around this? -- boniG When I said "there are none", I meant that none of the fields contain data of a sensitive or confidential nature. I even tried removing every field except the very first one which is simply a text field with the identificat...

Cannot open Outlook window. The set of folders cannot be opened
Please advise: This morning I wanted to copy my pst file to laptop -via home network. Outlook hickupped against that. I then made an archive file in same directory and copied that via via to laptop. NO SETTINGS WERE CHANGED. Then I closed doen computer normally. Now, returning home after work, starting Outlook, it gives the message: Unable to open Outlook window. The set of folders cannot be opened . Can anyone advise me please what I should be doing? thanks magsie Create a new mail profile - yours is now corrupt. -- Milly Staples [MVP - Outlook] Post all replies to the group to k...

reference is not valid message for pivot tables based on Access query
I've looked around but can't find an answer to this. I have a workbook - an xlt - that has 6 worksheets that pull data from different queries in the same Access database. I have several worksheets with on pivot table each. The pivot tables are based on dynamic named ranges in the external data worksheets. I use dynamic ranges because I have some adjacent calculated columns in the worksheets. The workbook has only 6 pivot caches - the same as the number of worksheets that pull data. I copied pivot tables from sheet to sheet so that they'd use the same cache, where approp...

missing all texts from mail messages
For some reason all text from all of my mail messages are missing. The only way I can read my mail messages is by saving them as *.txt files. I have relatively new XP version (got a new computer few weeks ago) with Outlook=20 Express 6. The mail messages were readable at first,=20 but the problem occurred after automatic windows updates=20 last week and I believe this has caused the problem. How=20 could I fix this? Automatic updates on my computer around the time the mail=20 message problem appeared:=20 Windows Media Player 9 Series (KB837272)=20 Windows XP -security update(KB840315)=20...

How to read xml to array using javascript
I'm new with XML. Please give me some advice. I wonder there are any difference between XML that is automatically generated from ADO and XML file that shows in many textbooks. I found that the formats are a bit difference. At the begining of the one that is automatically generated from ADO is usually like this <xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:dt="uuid: C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com: rowset" xmlns:z="#RowsetSchema"> - <s:Schema id="RowsetSchema"> - <s:E...

Screen size upon opening of Outlook
Is there a way to set the display to Maximize when outlook opens. It seems that every other day that when I open Outlook, I get a minimized screen. Is there something in the registry that I can configure so this doesnt happen anymore. Thanks Craig If you create a shortcut to Outlook.EXE you can set it to open maximized. "Craig" <beaky1211@hotmail.com> wrote in message news:eRUcOyLAGHA.912@TK2MSFTNGP11.phx.gbl... > Is there a way to set the display to Maximize when outlook opens. It > seems that every other day that when I open Outlook, I get a minimized >...