Changing size of excel sheet

Is it possible to make a worksheet smaller. What I want to do is to be able to tab from, a1 to b1 to c1 to d1 etc up to g1 and then if I tab again it goes to a2. Is this possible? Is there any way of making it skip the a coloumn when tabbing even if it has data in it?


Many thanks

Jack

Does this help

Select Range A1 to G2 and then press the tab key

VBA Noob

About the nearest would be to hide all the other Columns. Select Column H, then select all the other Columns to the right by clicking Ctrl & the Right arrow. Then from the Format menu select Columns>-Hide.

Hi,

Select the sheet you want to restrict, press Alt-F11 and bring up the properties for the sheet you want to restict. Enter a scroll area for the area you want to allow access to and save. The user then can't access cells outside the range you limit the scroll area to, so if you add formatting to the area outside the scroll area, you can make it look like the sheet is small (in effect it is but you have the benefit of being able to use the area outside the scroll area to put formulas etc. to service the active sheet area (I think this is in line with best practice too).

Stiles.

See if links help

http://www.exceltip.com/st/Preventin...Excel/177.html

http://www.ozgrid.com/VBA/limit-scrolling-vba.htm

http://www.ozgrid.com/Excel/limit-scrolling.htm

http://exceltips.vitalnews.com/Pages...roll_Area.html

VBA Noob

I don't think that the scroll area settings are retained when the workbok is closed, even after saving. In which case the scroll area would need to be set in the Workbook_Open event. If macros aren't enabled by the user, then the settings won't work.

Please Login or Register  to view this content.

Place in ThisWorkbook module

VBA Noob

Many thanks for everyones help. Two final questions on this. What do i have to add if i want a different scroll area on sheet2 and does anyone know any good books to get to learn basic and intermediate vba for excel2003? Many thanks jack

Try

Please Login or Register  to view this content.

See link about books. Viewing threads is also a good one to learn.

http://www.excelforum.com/showthread.php?t=628180

Also good link below

VBA Noob