Trying to save a .XLA file that's Read Only
 

Hi, I am trying to save an add-in file but whenever I click Save the
program tells me that this file is read-only and can only be saved as a
new file. When I complied and created a newly named .XLA file, I found
that this only saves a empty project.

I've went in to the Add-in folder in Windows Explorer and checked under
Properties. The file is not checked as Read-Only.

Can someone tell me why this is happening?

Thanks

Trying to save a .XLA file that's Read Only
 

Any chance you have multiple instances of excel running and so the file is in
use. (Although, I would have thought you would have gotten a "file in use
error".)

How about going into the VBE
hit ctrl-r to see the project explorer
Select your addin's project
click on ThisWorkbook
hit F4 to see its properties
scroll down to IsAddin
Change that to false

Then swap back to excel.
Activate your workbook
look at the title bar. Does it say ReadOnly?

If no, try file|saveas
remember to change the "save as type" to:
Microsoft Office Excel Add-In (*.xla)



silkworm wrote:

Hi, I am trying to save an add-in file but whenever I click Save the
program tells me that this file is read-only and can only be saved as a
new file. When I complied and created a newly named .XLA file, I found
that this only saves a empty project.

I've went in to the Add-in folder in Windows Explorer and checked under
Properties. The file is not checked as Read-Only.

Can someone tell me why this is happening?

Thanks

--

Dave Peterson

Trying to save a .XLA file that's Read Only
 

Thanks for the reply. I did have two instances of Excel running. Now
there is now problem.

Trying to save a .XLA file that's Read Only
 

now there is NO problem???

(typo, I hope!)

silkworm wrote:

Thanks for the reply. I did have two instances of Excel running. Now
there is now problem.

--

Dave Peterson

Trying to save a .XLA file that's Read Only
 

Oops, yes, I meant "no."