Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
cannot maximize or minimize
I opened a file today that did not open maximized by default like my other
files and it doesn't have the maximize, minimize and close icons on the top right of the blue bar. When I open any other file it opens maximized. Did I inadvertently screw up a setting on this file somewhere? The file contains macros and it opens the same way whether I enable or disable the macros. Thanks for any suggestions, Gary Beard |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
cannot maximize or minimize
This can be caused by Workbook protection (Tools, Protection, Unprotect
Workbook would turn it off). -- Jim sbcglobal.net" <gbeard12@<delete wrote in message et... |I opened a file today that did not open maximized by default like my other | files and it doesn't have the maximize, minimize and close icons on the top | right of the blue bar. When I open any other file it opens maximized. Did | I inadvertently screw up a setting on this file somewhere? The file | contains macros and it opens the same way whether I enable or disable the | macros. | | Thanks for any suggestions, | Gary Beard | | |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
cannot maximize or minimize
Hello Gary, When you close a file, it remembers the settings. Since you posted this question in an Excel newsgroup, I will assume these files are Excel Workbooks. Excel opens the workbook in another window. If the workbook window is maximized, the title bar (blue bar) disappears. The buttons are then moved below Excels title bar buttons on the right. If these are missing, I suspect the macros may be responsible for the buttons disappearing. Check the code. Sincerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=483171 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
cannot maximize or minimize
Jim,
I thought the same thing and turned off the protection and still had the problem. Thanks for the response, Gary Beard |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
cannot maximize or minimize
Leith,
The only thing in the macros are routines to sort and copy data from one sheet to another (one by alphabetical order and the other by numeric order). The workbook was protected...I thought I only protected the worksheet. Thanks again for your help Leith, Gary Beard |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
cannot maximize or minimize
Jim,
The workbook WAS protected...I thought I just had the worksheet protected. Thanks for the help! I really appreciate it! -- Gary Beard |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shortcut key minimize/maximize | Excel Discussion (Misc queries) | |||
how do i minimize/maximize a workbook from vba? I want to minimize it durring processing to speed things up a bit | Excel Worksheet Functions | |||
Maximize & Minimize where are you ? | Excel Programming | |||
Maximize & Minimize buttons where are they? | Excel Programming | |||
Minimize and Maximize Forms | Excel Programming |