At the moment i have a large spread sheet with a lot of macros, but i am
unable to view the whole screen,

Full screen option, works but the spreed sheet only covers half of the
screen, i can not drag the box or maximise or minimise, the spread sheets
works fine otherwise