| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Side-by-Side worksheets
I have two different worksheets (same workbook) displaying side-by-side in
the Excel window. Is it possible for one of the worksheets not to display the minimize and maximize window buttons? Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Side-by-Side worksheets
protect the workbook
-- Regards, Tom Ogilvy "Sheldon" wrote in message ... I have two different worksheets (same workbook) displaying side-by-side in the Excel window. Is it possible for one of the worksheets not to display the minimize and maximize window buttons? Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Side-by-Side worksheets
I must be missing something in your suggestion. The buttons are still
visible and functional. "Tom Ogilvy" wrote: protect the workbook -- Regards, Tom Ogilvy "Sheldon" wrote in message ... I have two different worksheets (same workbook) displaying side-by-side in the Excel window. Is it possible for one of the worksheets not to display the minimize and maximize window buttons? Thanks |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Side-by-Side worksheets
When you do
Tools=Protection you get two choices Structure and Window. Selecting at least the Window option does what I said. -- Regards, Tom Ogilvy "Sheldon" wrote in message ... I must be missing something in your suggestion. The buttons are still visible and functional. "Tom Ogilvy" wrote: protect the workbook -- Regards, Tom Ogilvy "Sheldon" wrote in message ... I have two different worksheets (same workbook) displaying side-by-side in the Excel window. Is it possible for one of the worksheets not to display the minimize and maximize window buttons? Thanks |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Side-by-Side worksheets
Sheldon
Protecting the workbook will disable the min/max buttons on both worksheets. I think you will have to place one of the worksheets in another workbook then have two workbooks open side by side. Protect one of the workbooks and not the other. Gord Dibben Excel MVP On Fri, 3 Sep 2004 15:09:36 -0400, "Tom Ogilvy" wrote: When you do Tools=Protection you get two choices Structure and Window. Selecting at least the Window option does what I said. -- Regards, Tom Ogilvy "Sheldon" wrote in message ... I must be missing something in your suggestion. The buttons are still visible and functional. "Tom Ogilvy" wrote: protect the workbook -- Regards, Tom Ogilvy "Sheldon" wrote in message ... I have two different worksheets (same workbook) displaying side-by-side in the Excel window. Is it possible for one of the worksheets not to display the minimize and maximize window buttons? Thanks |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Side-by-Side worksheets
the window without the focus doesn't show the buttons anyway (but will when
activated). So it is unclear to me what the user is trying to achieve. -- Regards, Tom Ogilvy "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Sheldon Protecting the workbook will disable the min/max buttons on both worksheets. I think you will have to place one of the worksheets in another workbook then have two workbooks open side by side. Protect one of the workbooks and not the other. Gord Dibben Excel MVP On Fri, 3 Sep 2004 15:09:36 -0400, "Tom Ogilvy" wrote: When you do Tools=Protection you get two choices Structure and Window. Selecting at least the Window option does what I said. -- Regards, Tom Ogilvy "Sheldon" wrote in message ... I must be missing something in your suggestion. The buttons are still visible and functional. "Tom Ogilvy" wrote: protect the workbook -- Regards, Tom Ogilvy "Sheldon" wrote in message ... I have two different worksheets (same workbook) displaying side-by-side in the Excel window. Is it possible for one of the worksheets not to display the minimize and maximize window buttons? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| worksheets side-by-side | Excel Discussion (Misc queries) | |||
| Viewing worksheets side by side | Excel Discussion (Misc queries) | |||
| How to display two worksheets from the same workbook side-by-side | Excel Worksheet Functions | |||
| print 2 worksheets on the same page side-by side | Excel Discussion (Misc queries) | |||
| How do I print 2 worksheets on the same page side-by side | Excel Discussion (Misc queries) | |||
Hybrid Mode
