window control
I recently downloaded an Excel file that will not allow me to resize the
workbook window. It also doesn't have the Minimize, Maximize, and Close buttons on the right side of the title bar for the workbook, and doesn't allow me to resize the window by clicking and dragging the borders. I didn't see a property in ThisWorkbook object that would explain this. How did they do that? |
window control
Hi Dave,
The workbook is probably protected. Choose Tools/Protection/Unprotect Workbook from the menu and you can unprotect it if it was not protect using a password. If it was protected using a password, download the free Excel Utilities from my web site below and you'll find a utility for removing workbook and worksheet protection passwords. -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * "Dave B" wrote in message ... I recently downloaded an Excel file that will not allow me to resize the workbook window. It also doesn't have the Minimize, Maximize, and Close buttons on the right side of the title bar for the workbook, and doesn't allow me to resize the window by clicking and dragging the borders. I didn't see a property in ThisWorkbook object that would explain this. How did they do that? |
window control
Tools|Protection|Protect WorkBook
and check the Windows option -- John Green - Excel MVP Sydney Australia "Dave B" wrote in message ... I recently downloaded an Excel file that will not allow me to resize the workbook window. It also doesn't have the Minimize, Maximize, and Close buttons on the right side of the title bar for the workbook, and doesn't allow me to resize the window by clicking and dragging the borders. I didn't see a property in ThisWorkbook object that would explain this. How did they do that? |
All times are GMT +1. The time now is 05:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com