J
Jim
I have an addin which contains several user defined functions. I am using
the Application.MacroOptions command to assign the functions to custom
categories. An example is:
Application.MacroOptions Macro:="BaPeq", Category:="Miscellaneous Functions"
The addin installs without any problems when loading the addin with Excel
already opened using Tools…Addins. But when I try to have Excel autoload the
addin every time Excel starts the I get the following error message:
Run-time error ‘1004’: Cannot edit a macro on a hidden workbook. Unhide
the workbook using the
unhide command.
Any suggestions on how to avoid this error message?
the Application.MacroOptions command to assign the functions to custom
categories. An example is:
Application.MacroOptions Macro:="BaPeq", Category:="Miscellaneous Functions"
The addin installs without any problems when loading the addin with Excel
already opened using Tools…Addins. But when I try to have Excel autoload the
addin every time Excel starts the I get the following error message:
Run-time error ‘1004’: Cannot edit a macro on a hidden workbook. Unhide
the workbook using the
unhide command.
Any suggestions on how to avoid this error message?