Hello
In my office Microsoft Excel version has been upgraded from 2003 to 2007. I developed some macros in 2003 version and they are working fine on my PC with Microsoft Excel 2007.
Recently I developed a macro in 2007 version and it is working fine but that macro is showing some error "Compile Error in Hidden Module" on my user's PC as my users are using Microsoft Excel 2003. I checked in VBA Editor under
Tool -> References that Ref Edit Control is missing. I unchecked it on my user's PC but i need some another solution to do it because this is not a smart way to solve it.
Actually VBA code for macro is password protected and I cant share that with my user. Please suggest some another solution as my user is facing same problem with other macros also.
Thanks a lot for your help!!!
In my office Microsoft Excel version has been upgraded from 2003 to 2007. I developed some macros in 2003 version and they are working fine on my PC with Microsoft Excel 2007.
Recently I developed a macro in 2007 version and it is working fine but that macro is showing some error "Compile Error in Hidden Module" on my user's PC as my users are using Microsoft Excel 2003. I checked in VBA Editor under
Tool -> References that Ref Edit Control is missing. I unchecked it on my user's PC but i need some another solution to do it because this is not a smart way to solve it.
Actually VBA code for macro is password protected and I cant share that with my user. Please suggest some another solution as my user is facing same problem with other macros also.
Thanks a lot for your help!!!