Can't re-size worksheet
 

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

Can't re-size worksheet
 

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

Can't re-size worksheet
 

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.

Atishoo;3515347 Wrote:
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
-




--
basils57