| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HIDING ROWS AND COLUMS
Hi all,
I have noticed that you can hide all the columns and rows that you are not using so the user cannot scroll past the relevant part of the worksheet. I can hide all the column cause there aren't too many of them when you scroll along but I tried this for the rows and it seems to just keep going on forever! lol Is there another way I can hide ALL the rows underneath so the end user can't scroll down? Cheers :) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
HIDING ROWS AND COLUMS
Do you want to hide all or would you be happy with restricting the
scroll area? For the latter simply change the "ScrollArea" property for the appropriate sheet. Doo0592 wrote: Hi all, I have noticed that you can hide all the columns and rows that you are not using so the user cannot scroll past the relevant part of the worksheet. I can hide all the column cause there aren't too many of them when you scroll along but I tried this for the rows and it seems to just keep going on forever! lol Is there another way I can hide ALL the rows underneath so the end user can't scroll down? Cheers :) |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
HIDING ROWS AND COLUMS
Rows(n & ":" & Rows.Count).Hidden = True
where n is some starting number. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Doo0592" wrote in message oups.com... Hi all, I have noticed that you can hide all the columns and rows that you are not using so the user cannot scroll past the relevant part of the worksheet. I can hide all the column cause there aren't too many of them when you scroll along but I tried this for the rows and it seems to just keep going on forever! lol Is there another way I can hide ALL the rows underneath so the end user can't scroll down? Cheers :) |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
HIDING ROWS AND COLUMS
Ok, showing my nooby colours on this one!
I have tried them both n neither have worked.. where do I put them and do they need a private sub? Doo Bob Phillips wrote: Rows(n & ":" & Rows.Count).Hidden = True where n is some starting number. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Doo0592" wrote in message oups.com... Hi all, I have noticed that you can hide all the columns and rows that you are not using so the user cannot scroll past the relevant part of the worksheet. I can hide all the column cause there aren't too many of them when you scroll along but I tried this for the rows and it seems to just keep going on forever! lol Is there another way I can hide ALL the rows underneath so the end user can't scroll down? Cheers :) |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
HIDING ROWS AND COLUMS
No sub required to restrict the scroll area ...
Go into the VBA editor but ensure that the Project and Properties windows are visible. In the Project window click on and highlight the sheet you want to restrict (e.g. Sheet1) and then scroll down to "ScrollArea" in the Properties window. Click there and enter the range you want to restrict to (e.g. A1:F6) Good Luck! Doo0592 wrote: Ok, showing my nooby colours on this one! I have tried them both n neither have worked.. where do I put them and do they need a private sub? Doo Bob Phillips wrote: Rows(n & ":" & Rows.Count).Hidden = True where n is some starting number. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Doo0592" wrote in message oups.com... Hi all, I have noticed that you can hide all the columns and rows that you are not using so the user cannot scroll past the relevant part of the worksheet. I can hide all the column cause there aren't too many of them when you scroll along but I tried this for the rows and it seems to just keep going on forever! lol Is there another way I can hide ALL the rows underneath so the end user can't scroll down? Cheers :) |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
HIDING ROWS AND COLUMS
Ahhh, silly me! Never thought to look there! :)
Thanks Alan x Alan wrote: No sub required to restrict the scroll area ... Go into the VBA editor but ensure that the Project and Properties windows are visible. In the Project window click on and highlight the sheet you want to restrict (e.g. Sheet1) and then scroll down to "ScrollArea" in the Properties window. Click there and enter the range you want to restrict to (e.g. A1:F6) Good Luck! Doo0592 wrote: Ok, showing my nooby colours on this one! I have tried them both n neither have worked.. where do I put them and do they need a private sub? Doo Bob Phillips wrote: Rows(n & ":" & Rows.Count).Hidden = True where n is some starting number. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Doo0592" wrote in message oups.com... Hi all, I have noticed that you can hide all the columns and rows that you are not using so the user cannot scroll past the relevant part of the worksheet. I can hide all the column cause there aren't too many of them when you scroll along but I tried this for the rows and it seems to just keep going on forever! lol Is there another way I can hide ALL the rows underneath so the end user can't scroll down? Cheers :) |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
HIDING ROWS AND COLUMS
Mission complete... nearly! :)
Doo0592 wrote: Ahhh, silly me! Never thought to look there! :) Thanks Alan x Alan wrote: No sub required to restrict the scroll area ... Go into the VBA editor but ensure that the Project and Properties windows are visible. In the Project window click on and highlight the sheet you want to restrict (e.g. Sheet1) and then scroll down to "ScrollArea" in the Properties window. Click there and enter the range you want to restrict to (e.g. A1:F6) Good Luck! Doo0592 wrote: Ok, showing my nooby colours on this one! I have tried them both n neither have worked.. where do I put them and do they need a private sub? Doo Bob Phillips wrote: Rows(n & ":" & Rows.Count).Hidden = True where n is some starting number. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Doo0592" wrote in message oups.com... Hi all, I have noticed that you can hide all the columns and rows that you are not using so the user cannot scroll past the relevant part of the worksheet. I can hide all the column cause there aren't too many of them when you scroll along but I tried this for the rows and it seems to just keep going on forever! lol Is there another way I can hide ALL the rows underneath so the end user can't scroll down? Cheers :) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hiding colums when saving as html | Excel Discussion (Misc queries) | |||
| Hiding a button when hiding rows | Excel Discussion (Misc queries) | |||
| How do change rows to colums AND columns to rows | Excel Discussion (Misc queries) | |||
| Print few rows with many colums so that rows wrap on printed pages | Excel Discussion (Misc queries) | |||
| colums and rows ... | Excel Worksheet Functions | |||
Hybrid Mode
