Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Attaching a particular user defined function to cust button | Excel Discussion (Misc queries) | |||
user defined date | Excel Worksheet Functions | |||
user defined formats for small numbers | Excel Discussion (Misc queries) | |||
User defined charts- font size too small | Charts and Charting in Excel | |||
how to move user defined function | Excel Worksheet Functions |