Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling Min and Max buttons in Excel Worksheet
Hello,
I recently recieved an Excel file from someone where the Min, Max & Close buttons of the Excel Worksheet are disabled. Also you cant move the Worksheet window around. How is that done ? How can they be enabled ? I know VBA coding & there are no Modules or code in the worksheet. Is this just a setting ? Any help would be greatly appreciated. Thank you, Jeff |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling Min and Max buttons in Excel Worksheet
Hi Jeff
The workbook is protected I think ToolsProtection.....Protect workbook (Select Windows) -- Regards Ron de Bruin http://www.rondebruin.nl "Jeff" wrote in message ... Hello, I recently recieved an Excel file from someone where the Min, Max & Close buttons of the Excel Worksheet are disabled. Also you cant move the Worksheet window around. How is that done ? How can they be enabled ? I know VBA coding & there are no Modules or code in the worksheet. Is this just a setting ? Any help would be greatly appreciated. Thank you, Jeff |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling Min and Max buttons in Excel Worksheet
Sorry I answered my own question...
It is Workbook protection, when on will disable them. Thnx, Myself "Jeff" wrote: Hello, I recently recieved an Excel file from someone where the Min, Max & Close buttons of the Excel Worksheet are disabled. Also you cant move the Worksheet window around. How is that done ? How can they be enabled ? I know VBA coding & there are no Modules or code in the worksheet. Is this just a setting ? Any help would be greatly appreciated. Thank you, Jeff |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disabling Excel 2000 worksheet printing | Excel Worksheet Functions | |||
Disabling Toolbar Buttons with no open Workbook | Excel Programming | |||
Disabling Minimise/Restore Down buttons | Excel Programming | |||
Disabling Toolbar buttons and CommandBar items | Excel Programming | |||
Option buttons - disabling | Excel Programming |