Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
The specific workbook opens each worksheet as a resized window about 95% of
screen with no minimize, resize, or close box in the top blue title bar of the worksheet. One worksheet Columns A and B appear hidden or off screen with a windows split pane. They cannot be restored (not even with the format column unhide executed from the worksheet global box selected using format/columns/ unhide. The windows split and unfreeze options are grayed out. |
#2
![]() |
|||
|
|||
![]()
The Workbook windows are protected.
To unprotect them (you may need a password): Choose ToolsProtectionsUnprotect workbook Wade www wrote: The specific workbook opens each worksheet as a resized window about 95% of screen with no minimize, resize, or close box in the top blue title bar of the worksheet. One worksheet Columns A and B appear hidden or off screen with a windows split pane. They cannot be restored (not even with the format column unhide executed from the worksheet global box selected using format/columns/ unhide. The windows split and unfreeze options are grayed out. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
![]() |
|||
|
|||
![]()
Thought that also, but the worksheet does not appear to be protected.
Although another user tried to protect the worksheet at one point, her password will not unprotect it. I can also enter in any cell and when I choose "ToolsProtection" I see the both the "unprotect" and the "protect" options are available, making me believe it is not protected and the problem is more than a "forgotten password". More ideas? Thanks, "Debra Dalgleish" wrote: The Workbook windows are protected. To unprotect them (you may need a password): Choose ToolsProtectionsUnprotect workbook Wade www wrote: The specific workbook opens each worksheet as a resized window about 95% of screen with no minimize, resize, or close box in the top blue title bar of the worksheet. One worksheet Columns A and B appear hidden or off screen with a windows split pane. They cannot be restored (not even with the format column unhide executed from the worksheet global box selected using format/columns/ unhide. The windows split and unfreeze options are grayed out. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#4
![]() |
|||
|
|||
![]()
The worksheet may be unprotected, but the workBOOK is protected.
They're two separate commands on the ToolsProtection menu. Wade www wrote: Thought that also, but the worksheet does not appear to be protected. Although another user tried to protect the worksheet at one point, her password will not unprotect it. I can also enter in any cell and when I choose "ToolsProtection" I see the both the "unprotect" and the "protect" options are available, making me believe it is not protected and the problem is more than a "forgotten password". More ideas? Thanks, "Debra Dalgleish" wrote: The Workbook windows are protected. To unprotect them (you may need a password): Choose ToolsProtectionsUnprotect workbook Wade www wrote: The specific workbook opens each worksheet as a resized window about 95% of screen with no minimize, resize, or close box in the top blue title bar of the worksheet. One worksheet Columns A and B appear hidden or off screen with a windows split pane. They cannot be restored (not even with the format column unhide executed from the worksheet global box selected using format/columns/ unhide. The windows split and unfreeze options are grayed out. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
automatically close hyperlink with back button | Excel Worksheet Functions | |||
Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
columns and rows on my worksheet will not stay resized | Excel Worksheet Functions | |||
Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
Worksheet name and Backward compatibility | Excel Discussion (Misc queries) |