Forum Discussion

tucsondonpepe's avatar
tucsondonpepe
Copper Contributor
Apr 24, 2020

Delete a print area label on a worksheet

Hi,

 

I would like to delete the print area labels on a worksheet. I find that the labels I used are not descriptive enough. Excel names the first print area as Print_Area. The next area would be labeled Print_Area_1. I would like to delete all of the labels or perhaps selected labels so I can enter a label name such as Print_Area_1_SUN.

Would appreciate your help with this.

 

Joe

2 Replies

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor

    Maybe this file, which contains a module with a PrintManager, will be of use to you. It has not been tested; please be sure to test it thoroughly beforehand—though it really *should* work.

    My answers are voluntary and without guarantee!

     

    Hope this will help you.

  • tucsondonpepe I normal circumstances we can not delete bulk print area. It has to be done manually. You can also seems to be get any VBA Code to do so if you search or research on the internet.