View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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