| 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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Side-by-Side worksheets
The writer is trying not to confuse the user. I want to eliminate the min,
max, and close buttons on the worksheets. I have placed a shape connected to macro which closes the work window, and maximizes the other window. The code previously mentioned in this thread seems to work - almost. The worksheet without the macro behind the shape does not allow all updates necessary. The other worksheet has cells where the user enters data (this continues to work fine), but it also has option buttons, which does not work in the side-by-side configuration. The option buttons only works when that worksheet is the only one displayed. "Tom Ogilvy" wrote: 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 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Side-by-Side worksheets
use option buttons from the forms toolbar. I couldn't find the Knowledge
base article on this, but I believe it is a known problem for activex controls. -- Regards, Tom Ogilvy "Sheldon" wrote in message ... The writer is trying not to confuse the user. I want to eliminate the min, max, and close buttons on the worksheets. I have placed a shape connected to macro which closes the work window, and maximizes the other window. The code previously mentioned in this thread seems to work - almost. The worksheet without the macro behind the shape does not allow all updates necessary. The other worksheet has cells where the user enters data (this continues to work fine), but it also has option buttons, which does not work in the side-by-side configuration. The option buttons only works when that worksheet is the only one displayed. "Tom Ogilvy" wrote: 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) | |||
Linear Mode
