How to Make workbook window bigger

[vishwajeet_chakravorty]

In one of my workbook, all the worksheet window have become 1/4 of the 100% in size and not at all getting bigger in any case. How to make it 100%?

 

[ShieBoon]

Try holding down the Ctrl key and scrolling your mouse

 

[vishwajeet_chakravorty]

This make the window Zoom. But I am asking about the size of the perticular window.

 

[ShieBoon]

U can try this.

Go to VB Editor, or press alt F11 to activate it.
In the Project Explorer, find ThisWorkBook. Double click it and you will see a blank page open up on its right. On top of the page you will see 2 drop down boxes. (General) and (Declarations)
Click on (General) and choose 'WorkBook'. Then on the 2nd drop down box beside 'WorkBook', select 'WindowResize'
Then type the following codes:
Wn.EnableResize = True

 

[ShieBoon]

After that you have to re-open your workbook to see the changes

 

[vishwajeet_chakravorty]

Dear when I press F11, it gives massage that this command is not available in a shared workbook. Now what to do?

 

[Roj47]

Is it possible that another user has opened it and changed the size settings and now that you are in the file; you are unable to amend until they close the file?

 

[ShieBoon]

Try to unprotect the sheet by going to,

Tools -> Protection -> Unprotect Sheet

 

[ShieBoon]

Sorry, i think that is the wrong solution. Try this instead.

http://www.groovypost.com/forum/mic...e-in-a-shared-workbook-excel-2010-t96057.html