Ungrouping sheet tabs with a Macro

  • Thread starter Thread starter Masters
  • Start date Start date
There doesn't seem to be a specific ungroup command. Just selecting an
individual sheet effectively ungroups the sheets:

Sheets("Sheet1").Select
 
I did try selecting one sheet and it does not ungroup unless I am holding
down the Ctrl button.
 

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

Macro code mod - add tabs/apply to entire workbook 2
Check for Grouping and Ungroup 4
ungroup columns in protected sheet 1
Testing for and ungrouping grouped sheets 4
Ungroup Sheets 2
Allow grouping / ungrouping while protecting the sheet 10
How to ungroup ? 1
group/ungroup 1

Back
Top