Workbook has [Group] at the end of teh file name when opened
 

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

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