Friday, March 27, 2015

macos - VBA Excel 2011 for Mac: Create custom category for user defined function error

I created several functions i.e.: "cal_adval". I would like to add it to a new function category named "Custom Clearance"



I read the documentation, and wrote this macro:



Sub add_category()

Application.MacroOptions Macro:="calc_adval", Category:="Customs Clearance"
Application.MacroOptions Macro:="calc_fodinfa", Category:="Customs Clearance"
Application.MacroOptions Macro:="calc_vat", Category:="Customs Clearance"
Application.MacroOptions Macro:="calc_liquidation", Category:="Customs Clearance"


End Sub


However I got this error: Method MacroOption of application failed. Any suggestions?

No comments:

Post a Comment

linux - How to SSH to ec2 instance in VPC private subnet via NAT server

I have created a VPC in aws with a public subnet and a private subnet. The private subnet does not have direct access to external network. S...