HI Earl

I have Never Entered a Code Before. Could you talk me through it?

Best
Stewa

"Earl Kiosterud" wrote:

Stew,

You can hide all the columns beyond your area, and all the rows also.

You can also set the Scroll Range, which you do for the sheet in the Visual Basic
Environment. I'm not sure if this is a persistent setting, which means that it might not
stay set when the workbook is reopened. In that case, you have to set it with Workbook_Open
code, which will run each time the workbook is opened. Macros must have been enabled.

--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"stew" wrote in message
...
Hi all

1st Question

Can I limit the visual area that can be viewed only to the area which has
information on a worksheet

2nd Question

can the tabs at the bottom showing the names of worksheets be colour coded
i.e. Data entry and read only different colours

Thank You for looking

Stew