Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I group a set of documents needs to be opened repetatively Prithvi New Users to Excel 1 August 25th 09 02:13 PM
Workbook has [Group] at the end of teh file name when opened MikeR-Oz New Users to Excel 2 September 12th 08 12:55 PM
stop excel file opened as read only if already opened by another u bobm Excel Programming 3 August 5th 05 04:11 PM
Is Workbook read-only because of file permission or because file is already opened? balexis Excel Programming 0 September 29th 04 02:29 PM
Opening a workbook if not opened, going to it if already opened neotokyo[_3_] Excel Programming 0 September 24th 04 08:56 PM


All times are GMT +1. The time now is 03:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"