XLA not loading properly on start-up

E

ExcelMonkey

I have an XLA with User Defined Functions in it. Upon loading I attempt to
load one of the function into a function category in Excel (UDF category 14)
When Excel starts up and opens the XLA I get an error message in the
ThisWorkbook module:

"Run time Error 1004: Cannot edit a macro on a hidden workbook. Unhide the
workbook using the Unhide command"

The code is as follws:
Private Sub Workbook_Open()
Application.MacroOptions Macro:="VowelCount", Category:=14
End Sub

Why is this happening? The XLA is obviously hidden. Do I have to
momentarily unihde it to add the funciton and then hide it again?

Thanks
 

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

XLA not opening properly (Repost) 3
Add-in - add a custom function to a custom group. 1
Putting UDF in custom or predefined function category 6
Handling a worksheet calculate event in XLA code 4
UDF XLA and SQL queries 1
Function Help in Add in 2
Issues with Referencing .XLA file on a Server 4
excel 2003 Reading workbook properties / details from an XLA how do you do it? 1

Top