Thread: Workbook has [Group] at the end of teh file name when opened
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Andy Pope Andy Pope is offline
external usenet poster
  
Posts: 2,489
Default Workbook has [Group] at the end of teh file name when opened
Hi,

Try,

activeworkbook.Sheets(1).select true

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"belinda" wrote in message
...

Is there a way to ungroup sheets using a script?

Thanks,

Belinda


--
belinda
------------------------------------------------------------------------
belinda's Profile: http://www.thecodecage.com/forumz/member.php?userid=40
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=18845


Reply With QuoteReply With Quote