Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting of workbook window
Hello
I seem to have lost the ability to re-size the active window in a excel file. I do not have the minimize, maximize and close button that are usually in the top right hand corner, and when I place th mouse over the edge of the window, I cannot drag it to make it bigger. I have looked throught the various vb codes that are on the worksheet and userforms in the file and can see nothing to remove or add thes functions. As I did not create this file, I'm not sure where else t look and have never had to figure out code for this. Thanks in advance, and hopefully someone can help -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting of workbook window
Try:
Tools | Protection | Unprotect Workbook (*not* Worksheet). -- Vasant "Candee" wrote in message ... Hello I seem to have lost the ability to re-size the active window in an excel file. I do not have the minimize, maximize and close buttons that are usually in the top right hand corner, and when I place the mouse over the edge of the window, I cannot drag it to make it bigger. I have looked throught the various vb codes that are on the worksheets and userforms in the file and can see nothing to remove or add these functions. As I did not create this file, I'm not sure where else to look and have never had to figure out code for this. Thanks in advance, and hopefully someone can help. --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting of workbook window
You workbook is protect Candee
If you protect a workbook in ToolsProtection..Protect Workbook with Windows checked you get this behavior -- Regards Ron de Bruin (Win XP Pro SP-1 XL2000-2003) www.rondebruin.nl "Candee" wrote in message ... Hello I seem to have lost the ability to re-size the active window in an excel file. I do not have the minimize, maximize and close buttons that are usually in the top right hand corner, and when I place the mouse over the edge of the window, I cannot drag it to make it bigger. I have looked throught the various vb codes that are on the worksheets and userforms in the file and can see nothing to remove or add these functions. As I did not create this file, I'm not sure where else to look and have never had to figure out code for this. Thanks in advance, and hopefully someone can help. --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting of workbook window
Thanks so much...feeling a little stupid now.......
Thanks agai -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot Resize Workbook window | Excel Discussion (Misc queries) | |||
Keep Workbook Window On Top | Excel Discussion (Misc queries) | |||
How do I capture the workbook window? | Excel Discussion (Misc queries) | |||
How do I open a workbook using a different window | Excel Discussion (Misc queries) | |||
The window opens in a smaller window not full sized window. | Excel Discussion (Misc queries) |