Can't re-size worksheet

For some reason when I open one particular Excel workbook it opens at about 50% size and without the Excel logo to the left of the heading and without the 'close', 'minimise' and 'resize' buttons to the top right.

Any attempt to resize it or even drag the sides or corner prove fruitless. All of my other workbooks open normally. Any ideas please?

I wonder if your workbbok has an open sub to size the view and remove the
button bars.
Have a look in vba editor (alt F11) double click "this workbook" and select
"workbook in the drop down menu. there may be a sub under wokbook open.
If so try deleting this, exiting the editor, and saving the book under a
different name before reopening.

"basils57" wrote:


For some reason when I open one particular workbook it opens at about
50% size and without the Excel logo to the left of the heading and
without the 'close', 'minimise' and 'resize' buttons to the top right.

Any attempt to resize it or even drag the sides or corner prove
fruitless. All of my other workbooks open normally. Any ideas please?




--
basils57

Thanks for the reply Atishoo, I have tried this but still get the same result.
(When I opened the editor as suggested it showed : "Private Sub Workbook_Open()

End Sub")

I can get around it by copying everything to a new workbook, but am intrigued as to how to rectify it.

Originally Posted by Atishoo

I wonder if your workbbok has an open sub to size the view and remove the
button bars.
Have a look in vba editor (alt F11) double click "this workbook" and select
"workbook in the drop down menu. there may be a sub under wokbook open.
If so try deleting this, exiting the editor, and saving the book under a
different name before reopening.

"basils57" wrote:


For some reason when I open one particular workbook it opens at about
50% size and without the Excel logo to the left of the heading and
without the 'close', 'minimise' and 'resize' buttons to the top right.

Any attempt to resize it or even drag the sides or corner prove
fruitless. All of my other workbooks open normally. Any ideas please?




--
basils57