| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ungrouping Sheets
Hi all
What is the correct syntax to ungroup sheets in a workbook? I want to make sure that no sheets have been grouped by a previous user of the files I'm opening (as this causes problems with certain VBA procedures I'm running on the files). Can't find anything on this in the VBA help file... Thxs! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Ungrouping Sheets
You just have to select one sheet.
If ActiveWindow.SelectedSheets.Count 1 Then ActiveWindow.SelectedSheets(1).Select End If -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Claude" wrote in message ... Hi all What is the correct syntax to ungroup sheets in a workbook? I want to make sure that no sheets have been grouped by a previous user of the files I'm opening (as this causes problems with certain VBA procedures I'm running on the files). Can't find anything on this in the VBA help file... Thxs! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Ungrouping Sheets
Just select any sheet.
Worksheets(1).Select -- Regards, Tom Ogilvy "Claude" wrote in message ... Hi all What is the correct syntax to ungroup sheets in a workbook? I want to make sure that no sheets have been grouped by a previous user of the files I'm opening (as this causes problems with certain VBA procedures I'm running on the files). Can't find anything on this in the VBA help file... Thxs! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Ungrouping Sheets
Or
Activesheet.Select -- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... Just select any sheet. Worksheets(1).Select -- Regards, Tom Ogilvy "Claude" wrote in message ... Hi all What is the correct syntax to ungroup sheets in a workbook? I want to make sure that no sheets have been grouped by a previous user of the files I'm opening (as this causes problems with certain VBA procedures I'm running on the files). Can't find anything on this in the VBA help file... Thxs! |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Ungrouping Sheets
Thanks!
"Chip Pearson" schrieb: You just have to select one sheet. If ActiveWindow.SelectedSheets.Count 1 Then ActiveWindow.SelectedSheets(1).Select End If -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Claude" wrote in message ... Hi all What is the correct syntax to ungroup sheets in a workbook? I want to make sure that no sheets have been grouped by a previous user of the files I'm opening (as this causes problems with certain VBA procedures I'm running on the files). Can't find anything on this in the VBA help file... Thxs! |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Ungrouping Sheets
Thanks!
"Tom Ogilvy" schrieb: Or Activesheet.Select -- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... Just select any sheet. Worksheets(1).Select -- Regards, Tom Ogilvy "Claude" wrote in message ... Hi all What is the correct syntax to ungroup sheets in a workbook? I want to make sure that no sheets have been grouped by a previous user of the files I'm opening (as this causes problems with certain VBA procedures I'm running on the files). Can't find anything on this in the VBA help file... Thxs! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot ungrouping on refresh? | Excel Discussion (Misc queries) | |||
| Ungrouping | Excel Discussion (Misc queries) | |||
| Ungrouping a Bar Chart | Charts and Charting in Excel | |||
| ungrouping clip art | Excel Discussion (Misc queries) | |||
| Ungrouping using vb | Excel Programming | |||
Linear Mode
