Macro Issue File Locked for editing

L

Lenny

Have set up an Icon on Toolbar with a standard Macro which I like to use.

But each time I open a new Excel get a message if have multiple instances of excel open..

FILE IN USE.

PERSONAL.XLS IS LOCKED FOR EDITING

Also How do I respond to a reply to a question placed on this website ....


EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com
 
D

Dave Peterson

If you're not going to change personal.xls, you could mark it readonly in
windows explorer.

I think most people try not to open multiple instances of excel. They'll just
open multiple files in a single instance.

I connect to the ms newsservers using a newsreader. I don't use the web
interface, so I don't know the answer to the second question.
 

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

Excel Macro --- personal.xls locked for editing 1
Macro --- Icon 2
Excel Macro -- Stop Record Button 2
File is locked for editing message 3
Macro that acts like function 3
Excel formatting of lines 2
Macro to Shade the selected cell 1
PERSONAL.xlsb locked for editing?? 3

Top