Ungrouping Sheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
Thanks!

Chip Pearson said:
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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Ungroup Sheets 2
Check for Grouping and Ungroup 4
VBA code to ungroup multiple groupings 6
Can Vba workout if a selection is part of a group? 0
Column grouping and hiding being over-ridden when sheet opened 3
Macro to Group andor Ungroup rows and/or columns 3
2002 vs 2007 MS Office Excel has encountered a problem and needs t 2
Allow grouping / ungrouping while protecting the sheet 10

Back
Top