Hiding Print area line

[oakley 0226]

So I have a sheet where I made it so A1 - R50 are all on 1 page, and I have data on S1 - Z50 are on page 2 to the right of it, I only wanted page 1 (A1 - R50) to print (along with other active sheets), will the data on the second page is visible, so I put set a print area around page 1... Works great, but the grey line from the print area shows and is really annoying, especially because I have gridlines turned off.... How can I hide the print area line with out. I have hidden group lines before using the below but am not sure how to do this one.

Hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate window
type this and hit enter.

activesheet.groupboxes.visible = false

If you only want to hide a single groupbox, you can use something like:

activesheet.groupboxes("group box 1").visible = false

 

[Peter_SSs]

Welcome to the MrExcel board!

In File -> Options, turn this setting off.

 

[oakley 0226]

Thank you for your response! will this apply to others automatically when i send them the excel or, will they then have to do it also? I am wanting it to be hidden to anyone i send it to automatically. thank you!

 

[oakley 0226]

I just found out making pagebreak false hides it but only in normal view, it remains visible in Page layout view. Is there any way to hide the print area line in page layout view?

 

[Peter_SSs]

Not that I know of.
As described in the Page Layout view pop-up, that view is to see how your printed documents will look. If it did not show where the print area starts & stops, how could it give any indication of that?

 

[oakley 0226]

Not that I know of.
As described in the Page Layout view pop-up, that view is to see how your printed documents will look. If it did not show where the print area starts & stops, how could it give any indication of that?

View attachment 105951

That makes sense, iim just trying to clean up my workbook and was hoping there was a way. Thanks for your response!

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.
(You never know - somebody else might come along with a way to do it. )