Cover sheets with windows

A sheet is a modal dialog that’s attached to a particular window—usually a document—and prevents further interaction with the window until the sheet is dismissed. When displayed, a sheet animates into view as if emerging from the window’s frame above the body area. Because a sheet is attached to a specific window, the user can always correlate the sheet with its parent window. In the case of a tabbed window, a sheet pertains to the active tab and the user can’t switch to another tab without first dismissing the sheet.

A sheet is a good way to request user input before proceeding with a document-specific action, such as attaching files, exporting, saving, and printing. Sheets are also used to present information to the user before the next step, like a licensing agreement that requires acceptance.

Use a sheet only when a window has a frame. Sheets should always emerge from a window’s frame above the body area.

Open sheets above other windows. In general, a window and its attached sheet should come to the front when the sheet opens. Once a sheet is displayed, the user should be able to click another window to bring it back to the front. Note that, when a document comes to the front, any modeless document-related panels should come to the front too.

Whenever possible, avoid displaying more than one sheet attached to a window at a time. If a user action within a sheet results in another sheet being displayed, consider closing the first sheet before displaying the new one. If necessary, you can display the first sheet again after the second one is dismissed.

Use an app-modal dialog instead of a sheet when the same document is opened in multiple windows. Some apps let the user open a document in multiple windows so they can view and edit different portions of the document at once. In this situation, it would be unclear that changes made in a single sheet affect all open document windows.

Use a panel instead of a sheet if the user needs to see or interact with the window in order to address the dialog. If the dialog requests information the user must get from the window, the dialog should not be a sheet. A panel is a better choice because it’s modeless and lets the user continue navigating the document to gather information. See Panels.

Use a panel instead of a sheet if the user needs to repeatedly provide input and observe results. A find and replace panel, for example, might let the user initiate replacements individually, so the result of each can be observed for correctness.

For related guidance, see Dialogs and Window Anatomy. For developer guidance, see the beginSheet method of NSWindow.

How to duplicate sheet in Excel with VBA

The tutorial provides a collection of macros to duplicate sheets in Excel: copy and rename based on cell value, copy multiple sheets, copy an active worksheet to another file without opening it, and more.

Manually copying sheets in Excel is pretty quick and straightforward. if performed just once or twice. Duplicating multiple sheets multiple times is boring and time consuming. On this page, you will find a handful of useful macros to automate this task.

Excel VBA to copy sheet to new workbook

This simplest one-line macro does exactly what its name suggests — copies the active sheet to a new workbook.

Copy multiple sheets in Excel with VBA

If you’d like to copy several sheets from the active workbook to a new one, select all the worksheets of interest and run this macro:

Excel VBA to copy sheet to another workbook

Depending on where you want to insert the copied sheet, use one of the following macros.

Copy sheet to the beginning of another workbook

This macro copies the active sheet before all other worksheets in the destination file, Book1 in this example. To copy to another file, replace «Book1.xlsx» with the full name of your target workbook.

Copy sheet to the end of another workbook

This piece of code duplicates the active worksheet and places the copy to the end of Book1. Again, please remember to replace «Book1.xlsx» with the name of your destination workbook.

Copy sheet to a selected workbook

To be able to copy the current sheet to any open workbook, you can create a UserForm (named UserForm1) with a ListBox control (named ListBox1) and two buttons:

Next, double-click the form and paste the below code in the Code window:

With the UserForm in place, you can use one of the following macros to copy the active sheet to the workbook of your choosing.

Copy sheet to the beginning of the selected workbook:

Copy sheet to the end of the selected workbook:

When run in Excel, the macro will show you a list of all currently opened workbooks. You select the needed one and click OK:

Excel macro to copy sheet and rename

When you copy a sheet in Excel, the replica is given a name in the default format like Sheet1 (2). The following macros can spare you the trouble of changing the default name manually.

This code duplicates the active worksheet, names the copy as «Test Sheet» (you are free to replace it with any other name you like), and places the copied sheet at the end of the current workbook.

To allow the user to specify the name for the copied sheet, use this code:

Upon running, the macro displays the following input box, in which you type the desired name and press OK:

Excel macro to copy sheet and rename based on cell value

In some situations, it may be more convenient to name a copy with a specific cell value, for example, a column header. For this, you simply take the above code and supply the value of the currently selected cell to the input box automatically. As with the previous example, the copy will be placed at the end of the active workbook.

The trickiest part would be to have your users always select the correct cell before running the macro 🙂

Alternatively, you can hardcode the address of the cell by which the copy should be named, cell A1 in the below code. To name the copied worksheet based on another cell, replace A1 with an appropriate cell reference.

Macro to copy worksheet to a closed workbook

This macro copies the active sheet to the end of a closed workbook. The name of another workbook is not specified in the code — the macro will open the standard Windows Explorer window and allow you to choose any destination file:

After you select the file and click Open, the macro will copy the active sheet and close the target workbook automatically.

Excel VBA to copy sheet from another workbook without opening

This macro enables you to copy a worksheet from another Excel file without opening it. The copied sheet will be inserted at the end of the current workbook.

Just remember to make a couple of replacements in the code:

• C:\Users\XXX\Documents\Target_Book.xlsx should be changed to the actual path and name of the workbook from which you want to copy a sheet.
• Sheet1 should be replaced with the name of the sheet you want to copy.

Excel VBA to duplicate sheet multiple times

Sometimes, you may need to duplicate the same sheet more than once, for instance to test different formulas on the same data set. This can be easily done with the following macro.

Open the original sheet, run the macro, specify how many copies of the active sheet you want to make, and click OK:

How to duplicate sheets in Excel with VBA

To copy a sheet in Excel with one of the above macros, you can either insert the VBA code into your own book or run a macro from our sample workbook.

How to add a macro to your workbook

To insert the code in your workbook, perform these steps:

1. Open the worksheet you want to copy.
2. Press Alt + F11 to open the Visual Basic Editor.
3. On the left pane, right-click ThisWorkbook, and then click Insert >Module.
4. Paste the code in the Code window.
5. Press F5 to run the macro.

For the detailed step-by-step instructions, please see How to insert VBA code in Excel.

How to run a macro from our sample workbook

Alternatively, you can download our sample workbook to Duplicate Excel Sheets and run the code from there.

The sample workbook contains the following macros:

CopySheetToNewWorkbook — copies the current worksheet to a new workbook.

CopySelectedSheets — copies multiple sheets that you select to a new workbook.

CopySheetToBeginningAnotherWorkbook — copies the active sheet to the beginning of another workbook.

CopySheetToEndAnotherWorkbook — copies the active sheet to the end of another Excel file.

CopySheetAndRename — duplicates the current sheet, renames it as specified by the user, and puts the copy after all other sheets in the current workbook.

CopySheetAndRenamePredefined — duplicates the active sheet, gives a hardcoded name to the copy and places it at the end of the current workbook.

CopySheetAndRenameByCell — makes a copy of the active sheet and renames it based on the selected cell value.

CopySheetAndRenameByCell2 — copies the active sheet and renames it based on the hardcoded cell address.

CopySheetToClosedWorkbook — allows you to copy sheet to a closed workbook.

CopySheetFromClosedWorkbook — enables you to copy a sheet from another Excel file without opening it.

DuplicateSheetMultipleTimes — lets you duplicate a sheet in Excel multiple times.

To run the macro in your Excel, just do the following:

1. Open the downloaded workbook and enable the content if prompted.
2. Open your own workbook and navigate to the sheet you want to copy.
3. In your worksheet, press Alt + F8 , select the macro of interest, and click Run.

That’s how you can duplicate a sheet in Excel with VBA. I thank you for reading and hope to see you on our blog next week!

cover sheet

1 cover sheet

2 cover sheet

обшивочный лист
—
[А.С.Гольдберг. Англо-русский энергетический словарь. 2006 г.]

Тематики

3 cover sheet

sheet buckling force — сила, необходимая для выгибания листа

ink sheet — лист, используемый в качестве резервуара краски

4 cover sheet

a sheet of ice — ледяное покрытие; ледяное поле

5 cover sheet

6 cover sheet

7 cover sheet

8 cover sheet

9 cover sheet

10 cover sheet

11 cover sheet

12 cover sheet

13 cover sheet

14 cover sheet

15 cover sheet

16 cover sheet

17 cover sheet

18 cover sheet

19 покровное стекло

См. также в других словарях:

cover sheet — cover page UK / US or cover sheet UK / US noun [countable] Word forms cover page : singular cover page plural cover pages the first page of a fax message, giving information such as the name and fax number of the person sending it … English dictionary

cover sheet — variant UK US Main entry: cover page … Useful english dictionary

Manila cover sheet — Верхний лист (декеля) из манильского картона … Краткий толковый словарь по полиграфии

cover page — UK / US or cover sheet UK / US noun [countable] Word forms cover page : singular cover page plural cover pages the first page of a fax message, giving information such as the name and fax number of the person sending it … English dictionary

cover page — UK US noun [countable] [singular cover page plural cover pages] the first page of a fax message, giving information such as the name and fax number of the person sending it Thesaurus: fax, telex and telegrams and bleepers … Useful english dictionary

cover page — cover ,page or cover ,sheet noun count the first page of a FAX message, giving information such as the name and fax number of the person sending it … Usage of the words and phrases in modern English

sheet — noun 1 large piece of fabric used on a bed ADJECTIVE ▪ clean, crisp, fresh ▪ a pile of clean sheets ▪ crumpled, rumpled (esp. AmE) ▪ … Collocations dictionary

Sheet music — For other uses, see Sheet music (disambiguation). Sheet music is written representation of music. This is a homorhythmic (i.e., hymn style) arrangement of a traditional piece entitled Adeste Fideles, in standard two staff format for mixed voices … Wikipedia

sheet — Ⅰ. sheet [1] ► NOUN 1) a large rectangular piece of cotton or other fabric, used on a bed to cover the mattress or as a layer beneath blankets. 2) a broad flat piece of metal or glass. 3) a rectangular piece of paper. 4) an extensive layer or… … English terms dictionary

Sheet film — is large format and medium format photographic film supplied on individual sheets of acetate or polyester film base rather than rolls. Sheet film was initially supplied as an alternative to glass plates. The most popular size measures 4×5 inches; … Wikipedia

Sheet — Sheet, v. t. [imp. & p. p. ; p. pr. & vb. n. .] 1. To furnish with a sheet or sheets; to wrap in, or cover with, a sheet, or as with a sheet. The sheeted dead. When snow the pasture sheets. Shak. [1913 Webster] 2. To expand, as … The Collaborative International Dictionary of English