Can't re-size worksheet

  • Thread starter Thread starter basils57
  • Start date Start date
B

basils57

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

Any attempt to resize it or even drag the sides or corner prov
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.
 
Thanks for the reply Atishoo, I have tried this but still get the sam
result.
(When I opened the editor as suggested it showed : "Private Su
Workbook_Open()

End Sub")

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

Check the extension of the file u are opening with the excel.
I m quite sure that the file is not excel file.


learn - n - enjoy
 
Back
Top