Is the XLSTART folder on a network drive?
How are you opening "any other excel"?
Are you double-clicking on an excel file?
First: a couple of definitions:
when you double-click the Excel icon (not a file, but the Excel application
icon)
It opens an "instance" of Excel.
It's like loading the entire Excel "software" into memory (ok, not really, but
it's an analogy)
If you double-click the Excel icon again, it opens a SECOND "instance".
If you've ever opened two excel files and tried to do a formula like "=WB2!A3"
so that it brings the content of the A3 cell of the second workbook (WB2) into
the current
workbook, you'd find that this only works if the two workbooks are in the same
"instance".
NORMALLY, when you double-click an excel file, it opens in a SHARED instance.
That way, data can be exchanged, and Windows doesn't have the extra "overhead"
of having
the application loaded more than once.
Now.. your configuration is "normally" set up to opan all files in the xlstart
folder whenever
you open an INSTANCE of Excel.
That means that if Excel is not open, and you double-click on any Excel file,
it
opens that file,
but then opens all files in the XLstart folder.
But if your Windows setup is designed to open SEPARATE instances when you open
workbooks, then the files in XLstart will open IN EACH INSTANCE.
When you open a second file, since the files in the XLstart folder were already
opened in the
FIRST instance, it will notify you that you're opening them as Read-Only in the
second instance.
So.. I THINK your problem is actually that your Windows setup is opening Excel
in separate instances.
To fix that,
Open "My Computer" (or Windows Explorer)
Go to Tools->Folder Options
and select the File Types tab.
Go to the .XLSB extension and click the "Advanced" button.
select "Open" and the "Edit" button.
Your application should read:
"C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" /e "%1"
the "Use DDE" checkbox should be SELECTED.
DDE Message:
[Open("%1")]
then, here's something that I discovered several months ago.
It seems that the %1 in the Application box, and the %1 in the DDE Message box
causes the file to be opened TWICE!
(I found it in opening some LARGE files with EXTENSIVE macros)
the trick I found is that you need to make an entry in the
DDE Application Not Running box:
[Rem Comment]
this is a non-executable comment, so it doesn't DO anything, but evidently it
makes it work properly...
You'll need to change these settings for .XLS, .XLSX, .XLSM
hope this helps,
Paul
>
>From: sudheer lolla <sudheer1...@gmail.com>
>To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
>Sent: Wed, October 13, 2010 7:18:46 AM
>Subject: $$Excel-Macros$$ XLSB and XLSX related problem
>
>Hi
>
>
>This is a very peculiar problem which am facing
>
>
>i have an xlsb which has some macros and is placed in XLSTART folder
>
>
>when an excel is opened the XLSB is attached to the XLSX file
>
>
>iam saying attached because when any other excel is opened,XL is popping up
>message saying "XYZ.xlsb is READ-ONLY"
>
>
>i dont want this to happen.so when ever any other excel opens that has to open
>smoothly without any popups.How to do that?
>--
>sudheer.L
>--
>----------------------------------------------------------------------------------
>
>Some important links for excel users:
>1. Follow us on TWITTER for tips tricks and links :
>http://twitter.com/exceldailytip
>2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>3. Excel tutorials at http://www.excel-macros.blogspot.com
>4. Learn VBA Macros at http://www.quickvba.blogspot.com
>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>To post to this group, send email to excel-macros@googlegroups.com
>
><><><><><><><><><><><><><><><><><><><><><><>
>Like our page on facebook , Just follow below link
>http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
