![]() |
Assigining User Defined Functions to Categories in Addins
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? |
All times are GMT +1. The time now is 05:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com