Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting sheet
I have a file with 1 Master sheet (Information of 35 Sales Fields) 35 Sheets
(1 for every single field), every week we have to send a copy of every field to the correspondent manager. My purpose is to automate this task as follow: Select the sheet (Field) and Uusing this macro (a button open the user form) : Private Sub UserForm_Activate() With ActiveWorkbook For I = 1 To .Sheets.Count ComboBox1.AddItem .Sheets.Item(I).Name Next End With End Sub This macro only select the sheet and keeps the form open, I need to continue to copy the sheet to a new file then get the user form closed. Could somebody give me a hand .. Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting rows to another sheet | Excel Worksheet Functions | |||
Selecting sheet with VB | Excel Discussion (Misc queries) | |||
Selecting Last Sheet | Excel Worksheet Functions | |||
Selecting a sheet from a drop down box | Excel Discussion (Misc queries) | |||
Selecting sheet after Userform | Excel Programming |