ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   how can I print pages without text frames on it? (https://www.excelbanter.com/setting-up-configuration-excel/230355-how-can-i-print-pages-without-text-frames.html)

marjattanb

how can I print pages without text frames on it?
 
Hello,

I have an Excel-sheet with macro buttons instructions about filling it in
text frames.

When printing the page these frames will be also printed as I only would
like to print the page as it is without text-frames or macro buttons.

Would anyone know if this is possible?



kassie

how can I print pages without text frames on it?
 
As far as the buttons are concerned, set their PrintObject property to False.
As far as the frames are concerned - you don't want frames, you don't add
frames

--
HTH

Kassie

Replace xxx with hotmail


"marjattanb" wrote:

Hello,

I have an Excel-sheet with macro buttons instructions about filling it in
text frames.

When printing the page these frames will be also printed as I only would
like to print the page as it is without text-frames or macro buttons.

Would anyone know if this is possible?



marjattanb

how can I print pages without text frames on it?
 
Thanks - that solved all my problems!!

"Kassie" wrote:

As far as the buttons are concerned, set their PrintObject property to False.
As far as the frames are concerned - you don't want frames, you don't add
frames

--
HTH

Kassie

Replace xxx with hotmail


"marjattanb" wrote:

Hello,

I have an Excel-sheet with macro buttons instructions about filling it in
text frames.

When printing the page these frames will be also printed as I only would
like to print the page as it is without text-frames or macro buttons.

Would anyone know if this is possible?




All times are GMT +1. The time now is 02:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com