| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select All Sheets in Workbook
Hi everyone
I recorded a macro to "Select All Sheets" in a workbook, then make a few column formatting changes and then "Ungroup Sheets". But when run as a Sub Procedure only the ActiveSheet is changed. It appears that selecting all sheets and making any changes manually will work but not when run as a sub Procedure. Is this a default condition of Excel, if so is there a work around? TIA -- Thank you Regards Bob C Using Windows XP Home + Office 2003 Pro |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select sheets ina workbook based on radio buttons and move them | Excel Worksheet Functions | |||
| How can I print only select sheets in my workbook? | New Users to Excel | |||
| macro to select sheets/page in a workbook and print them | Excel Programming | |||
| Sheets select method fails when workbook is opened by another workbook | Excel Programming | |||
| Copy select sheets to another Workbook | Excel Programming | |||
![Robert Christie[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
