I FOUND OUT THAT IN ANY OF MODULE , VARIABLE DECLARATION WAS PENDING, THATS WHY IT WAS NOT ACCEPTING THE MACRO RECORDING,..MAKE SURE YOU HAVE 'CHECKED MACROS BY 'COMPILE VBA PROJECT' FIRST AND THEN TRY RECORDING OR RUNNING MACRO.