Hi All,

I have a user whos computer skills are zero and does not understand
the concept of directories and there use.
I would like to restrict him from saving Excel files only in the
directory h:\excel & sub-directories underneath it.

I was thinking of a startup macro which could do the job, check the
path and if the path is not h:\excel it would change the path to h:
\excel and list the sub-directoreis and let the user save the file.

All suggestions are welcome and even more appreciated is a macro that
would do the job as my programming skills are very very minimum.

thanks in advance ,

Dave

Perhaps you can use ThisWorkbook's BeforeSave event to control this. I'm
thinking you could save the workbook out to wherever you want from here and
then set the event's Cancel argument to True to stop the save operation that
the user initiated.

--
Rick (MVP - Excel)


"Dave" wrote in message
...
Hi All,

I have a user whos computer skills are zero and does not understand
the concept of directories and there use.
I would like to restrict him from saving Excel files only in the
directory h:\excel & sub-directories underneath it.

I was thinking of a startup macro which could do the job, check the
path and if the path is not h:\excel it would change the path to h:
\excel and list the sub-directoreis and let the user save the file.

All suggestions are welcome and even more appreciated is a macro that
would do the job as my programming skills are very very minimum.

thanks in advance ,

Dave