Do you have access to the addins code ??
ie. is it password protected ??
If not then set the Thisworkbook Isaddin property
to False. You should be able to view the sheets
and make amendments. Don't forget to save and then
change it back to true.
If it is password protected then all you can do is see the sheets by running this code.
Sub GetXLA_Sheets()
Set xlaWB = Workbooks("TestXLA.xla")
For Each xlaSh In xlaWB.Sheets
xlaSh.Visible = True
xlaSh.Copy After:=ThisWorkbook.Sheets(Sheets.Count)
Next
End Sub
Change TestXLA.xla to the name of the addin.
Ivan
xla files are't that much different from xls files except the xla is normally a database and template. Files opened and saved as from an xla have take all the macros and formatting in them. You'll probably find the macro makes hidden sheets visible and gets or posts data then hides them again. Try format sheets unhide or if that doesn't work click esc edit while the macro is running and see if you can fiqure out what's going on
i have access to the xla code, but in the xla code i have excell object and the one with the sheet is password protected..i will try it with your code
thanx
i have access to the xla code, but in the xla code i have excell object and the one with the sheet is password protected..i will try it with your code
it did give me the sheets in the workbook but all i see is a grey sheet with no text on it
when i manually enter a cell and column like r2c3
then i can see in the formulabar what is in it.
how can i make al my cells visible.
??
thanx
Click on the intersection of the cells @ the top
The select Format /Row /unhide
format / column / unhide
Ivan
i dont even have rows or columns with intersections only one grey screen.
but when i manually give in row 10 column 10 then i see in the formulabar what is in it
Press F5
Type in Iv256
Now press F5 again
Type in A1
Hold shift key
and press enter
Click Format / column / unhide
All columns should be unhidden
Do the same with the rows except last row
address is A65536
Ivan
i tried but i doesn't work, if i insert colums i can select those but my cursor won't go anyfurther then the just inserted column i can't select the column next to it it seems it's blocking the cell for selecting
strange but true