Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
limit worksheet size | Excel Discussion (Misc queries) | |||
Worksheet Size | Excel Discussion (Misc queries) | |||
worksheet size | Excel Discussion (Misc queries) | |||
Size of a Worksheet | Excel Worksheet Functions | |||
worksheet size | Excel Discussion (Misc queries) |