Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Dealing with worksheet groups
I have been using the group selection feature of Excel for
years to print multiple worksheets all at once or to apply formatting to a set of worksheets. My problem is that the indicator at the bottom of the screen in not very noticeable and too often I save a file with worksheet groups enabled and when I reopen it later I enter numbers in cells and everything gets screwed up. I created a macro in Word to select the entire page, update all fields and then print. Is it possible to create a macro that prints all the worksheets if groups are turned on and then turns off groups when the printing is done. Similarly when a file is closed it turns off groups before saving the file. I have looked in the tool bar for buttons to turn groups off and on and cannot find them. Thanks for any help. Bob Kufrin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
help! making a worksheet more automated? | Excel Discussion (Misc queries) | |||
Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
Worksheet name and Backward compatibility | Excel Discussion (Misc queries) |