Working directory

R

Rick Sanderson

Hi,
is it possible to instruct excel to a specific directory when saving, to
avoid having to browse to it when creating documents using a template?
Regards,
Rick
Also is it possible to limit a spreadsheet to a certain number of rows and
columns similar to when creating a table in a word processor document?
 
G

GB

Question 1: Tools ... options ... general tab .... default file locations

Question 2: No, although you can hide columns and rows not in use.

Geoff
 
R

Rick Sanderson

GB said:
Question 1: Tools ... options ... general tab .... default file locations

Question 2: No, although you can hide columns and rows not in use.

Geoff
Click to expand...
Many thanks.
Rick
 
R

Rick Sanderson

Earl Kiosterud said:
Rick,

If you mean you want to limit the cells the user can select on a worksheet,
you can use:

Sheets("Sheet1").ScrollArea = "B2:G200"

Seems to me this one isn't persistent, so upon reopening the file, the
ScrollArea has to be set again. Not sure. This could be in Workbook_Open
in module ThisWorkbook.

Another option is using Tools - Protection - Protect Sheet. The unlocked
cells won't be selectable if the "Select locked cells" option isn't checked.
This allows multiple areas to be selectable.
Click to expand...
Hi, is that a feature in a newer version, im using Office 97, it sounds like
just what i am after, does it mean that the arrow or tab keys will ignore
the cell rather than move into it but tell you that data cannot be entered?
Cheers
Rick
 
E

Earl Kiosterud

Rick,

Either technique will disallow selecting cells other than intended. They
just won't be selectable by any means.

Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------
 
Top