Hi,
I created a macro, and i created the VBA project i added one customized function in a Module(Module1) in Excel 2010.
I saved that excel and the VBA Project, i tested in the excel, its works fine. once i closed the excel and the VBA project is automatically closed
THe problem is, I opened the same excel file again, i am trying to use the function, excel shows an error. Immediately I went to View Macros, my macro is not there.
How to set/run the macro in excel2010 even i closed and reopened the excel
I created a macro, and i created the VBA project i added one customized function in a Module(Module1) in Excel 2010.
I saved that excel and the VBA Project, i tested in the excel, its works fine. once i closed the excel and the VBA project is automatically closed
THe problem is, I opened the same excel file again, i am trying to use the function, excel shows an error. Immediately I went to View Macros, my macro is not there.
How to set/run the macro in excel2010 even i closed and reopened the excel
Comment