Maybe

A toggle macro to show sheet right to left and then back again

ActiveSheet.DisplayRightToLeft = Not ActiveSheet.DisplayRightToLeft
VBA Noob