ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Make a report with more lines that you can see on the screen (https://www.excelbanter.com/excel-discussion-misc-queries/179567-make-report-more-lines-you-can-see-screen.html)

Palle korsholm

Make a report with more lines that you can see on the screen
 
I have created a model in a sheet. When the users work in the model I like to
let then only like from row 1 to 41 but when they print it I like to have a
print from row 1 to 51.

It is of cause possible to make a macro but I would -due to that the users
is not experts €“ try to avoid this

Du any of you have an idea

--
Palle korsholm

Jim Rech[_2_]

Make a report with more lines that you can see on the screen
 
Without a macro I think your only option is to display rows 42-51 but
protect them from being changed.

--
Jim
"Palle korsholm" wrote in message
...
|I have created a model in a sheet. When the users work in the model I like
to
| let then only like from row 1 to 41 but when they print it I like to have
a
| print from row 1 to 51.
|
| It is of cause possible to make a macro but I would -due to that the users
| is not experts - try to avoid this
|
| Du any of you have an idea
|
| --
| Palle korsholm




All times are GMT +1. The time now is 10:43 AM.

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