Add horizontal lines to plot after changing to Log scale in VBA

I need to change my y-axis to Logarithmic scale, however, after doing so the horizontal lines are removed, i.e. the lines indicating which level the y-axis is at. Is there a way to add this with VBA? I used

.Axes(xlValue).ScaleType = xlScaleLogarithmic
.Axes(xlValue).LogBase = 2.7

to change the y-axis to log, however, now it looks something like this

and I want it to like something like this (this is another plot, I just want to illustrate how I want the horizontal lines).

Note that the horizontal lines are only removed when I change to log scale.