Working directory

  • Thread starter Thread starter Rick Sanderson
  • Start date Start date
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?
 
Question 1: Tools ... options ... general tab .... default file locations

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

Geoff
 
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
 
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
 
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
-------------------------------------------
 
Back
Top