For your info ...
Just dowloaded the file : Test Shift Sample V1.xlsm
in order test it again...and ... everything seems to function as expected
I clicked on this file and downloaded it again . Opened it and clicked on the button after enabling macros, nothing happens. It runs and stops, cells are blank. Do I need to call any procedure or something?