XL5: Can't Ungroup Module Sheet While Editing Worksheet Object |
In Microsoft Excel, if you copy a selection on a worksheet while multiple sheets are selected, and you paste the selection as a Microsoft Excel 5.0 Worksheet object in another application (client), you cannot ungroup a module sheet from the selected sheets when you edit the worksheet object in the client application.
When you select multiple sheets in a workbook, and copy a range of
cells on a worksheet, and then paste the selection as a worksheet
object in a client application, the sheets remain selected (grouped)
when you edit the worksheet object. When the group of sheets includes
a module sheet, the module sheet remains selected even after choosing
the Ungroup Sheets command.
This behavior occurs because you cannot select a module sheet in a
Microsoft Excel 5.0 Worksheet object. However, this means that if you
select a module sheet before you create the worksheet object, you cannot
ungroup the module sheet when you edit the object.
Because you cannot ungroup a module sheet in a worksheet object, certain
actions such as Delete Sheet and Move Or Copy Sheet (Edit menu) affect the
module sheet as well as the selected worksheet.
To avoid this behavior, do not include a module sheet in the selection of sheets when you copy a range of cells in group mode in order to paste them as a worksheet object in another application.
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article. This problem was corrected in a
later version of Microsoft Excel.
In Microsoft Excel version 5.0c, when you edit a Microsoft Excel version
5.0 Worksheet object that contains a module sheet in group mode, the
object opens in Microsoft Excel, instead of being activated for in-place
editing in the client application.
Note that you cannot ungroup selected sheets in a Microsoft Excel 5.0 Worksheet object by selecting a sheet tab of one of the inactive sheets. Instead, to ungroup selected sheets while editing a worksheet object in a client application, click the right mouse button on one of the sheet tabs, and choose Ungroup Sheets.
For more information about Canceling A Group Selection or Selecting All Sheets, choose the Search button in Help and type:
selecting worksheets
Additional query words: 4.00 6.00 6.00a officeinterop winppt macppt linking embedding ole
Keywords :
Version : 5.00
Platform : WINDOWS
Issue type :
Technology :
|
Last Reviewed: September 20, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |