Open worksheets in an xla for editing

Re: Open worksheets in an xla for editing

Have you tried copying the .xla file - saving it somewhere and then renaming it - ie changing the extension to .xls?

General advice on .xlas is to save an .xls duplicate, prior to converting the original to an .xla

Re: Open worksheets in an xla for editing

JJacob

I just did a quick test and this opened the worksheet in xl97:

Open the xla file
Open the VBEditor
Select View>Properties Window
Select View>Project Explorer
In Project Explorer, highlight ThisWorkbook
In Properties - ThisWorkbook change the IsAddin property = False

I could then edit the worksheet, but I didn't save or test any changes, so you're on your own after that.

P.S. Just wondering... Since changing the Addin property to True hides the worksheets in a xls file, could this be a solution for those wishing to only display a userform? i.e...

Displaying userform

If Not ThisWorkbook.IsAddin = True Then ThisWorkbook.IsAddin = True
UserForm1.Show

Returning to workbook

Unload UserForm1
If Not ThisWorkbook.IsAddin = False Then ThisWorkbook.IsAddin = False

Re: Open worksheets in an xla for editing

An xla wa once an xls as have been pointed out above, some guys save original and convert to xla, some dont, this is my prefered menthod, however if you change the isaddin properties in the VBE Properties then the xla will revert back to xls format ie sheets can be viewed, but this is still not an xls it is only a fully open xla, save will save changes if you save inside the vbe, do not save in excel itself, and do not forget to complie the project / xla before converting back to closed xla in the VBE properties.

This advice assumes you have access and the xla is not password protected.

Jack