"Dave Peterson" wrote:

Are you trying to make it so you don't have to check the box each time?

If that's what you meant, you can make this the default settings for new
workbooks by creating/modifying a template file.

If you create a workbook named Book.xlt and save it into your XLStart folder,
every new workbook that you create will inherit this attribute.

So you can set up page layout, header/footers as well as
file|properties|summary tab|save preview picture.

If you're looking for the location of your XLStart folder:

Open excel
alt-f11 to get to the vbe
ctrl-g to see the immediate window

type this and hit enter
?application.startuppath

For me (xl2002 and win98), I get:
C:\WINDOWS\Application Data\Microsoft\Excel\XLSTART

Kelly Lum wrote:

Dear Sir,

I am using ecxel 2000 and usually whsn saving a file, I
would put in a checkbox for preview.This is meant for
when searching files to see a small little picture on the
left corner to show u how the file l;ookss like. Can u
help1 Thank and awaiting yr favorble reply.Thank you once
agin.

Rgds
Kelly Lum

--

Dave Peterson

Will this work in 2003. I have several clients that have hundreds of files
that do not have the picture preview option checked. They are doing each one
individually.......

"Dave Peterson" wrote:

Are you trying to make it so you don't have to check the box each time?

If that's what you meant, you can make this the default settings for new
workbooks by creating/modifying a template file.

If you create a workbook named Book.xlt and save it into your XLStart folder,
every new workbook that you create will inherit this attribute.

So you can set up page layout, header/footers as well as
file|properties|summary tab|save preview picture.

If you're looking for the location of your XLStart folder:

Open excel
alt-f11 to get to the vbe
ctrl-g to see the immediate window

type this and hit enter
?application.startuppath

For me (xl2002 and win98), I get:
C:\WINDOWS\Application Data\Microsoft\Excel\XLSTART

Kelly Lum wrote:

Dear Sir,

I am using ecxel 2000 and usually whsn saving a file, I
would put in a checkbox for preview.This is meant for
when searching files to see a small little picture on the
left corner to show u how the file l;ookss like. Can u
help1 Thank and awaiting yr favorble reply.Thank you once
agin.

Rgds
Kelly Lum

--

Dave Peterson

Carolyn

Dave's method works for all NEW workbooks.

Previously saved books must be done individually, although someone may come up
with some code to alter existing books.


Gord Dibben Excel MVP

On Wed, 30 Mar 2005 12:07:01 -0800, "Carolyn Crandall"
wrote:

Will this work in 2003. I have several clients that have hundreds of files
that do not have the picture preview option checked. They are doing each one
individually.......

"Dave Peterson" wrote:

Are you trying to make it so you don't have to check the box each time?

If that's what you meant, you can make this the default settings for new
workbooks by creating/modifying a template file.

If you create a workbook named Book.xlt and save it into your XLStart folder,
every new workbook that you create will inherit this attribute.

So you can set up page layout, header/footers as well as
file|properties|summary tab|save preview picture.

If you're looking for the location of your XLStart folder:

Open excel
alt-f11 to get to the vbe
ctrl-g to see the immediate window

type this and hit enter
?application.startuppath

For me (xl2002 and win98), I get:
C:\WINDOWS\Application Data\Microsoft\Excel\XLSTART

Kelly Lum wrote:

Dear Sir,

I am using ecxel 2000 and usually whsn saving a file, I
would put in a checkbox for preview.This is meant for
when searching files to see a small little picture on the
left corner to show u how the file l;ookss like. Can u
help1 Thank and awaiting yr favorble reply.Thank you once
agin.

Rgds
Kelly Lum

--

Dave Peterson

I think that any code would have to use Sendkeys, too (which makes it
unreliable, well, for me anyway).

Gord Dibben wrote:

Carolyn

Dave's method works for all NEW workbooks.

Previously saved books must be done individually, although someone may come up
with some code to alter existing books.

Gord Dibben Excel MVP

On Wed, 30 Mar 2005 12:07:01 -0800, "Carolyn Crandall"
wrote:

Will this work in 2003. I have several clients that have hundreds of files
that do not have the picture preview option checked. They are doing each one
individually.......

"Dave Peterson" wrote:

Are you trying to make it so you don't have to check the box each time?

If that's what you meant, you can make this the default settings for new
workbooks by creating/modifying a template file.

If you create a workbook named Book.xlt and save it into your XLStart folder,
every new workbook that you create will inherit this attribute.

So you can set up page layout, header/footers as well as
file|properties|summary tab|save preview picture.

If you're looking for the location of your XLStart folder:

Open excel
alt-f11 to get to the vbe
ctrl-g to see the immediate window

type this and hit enter
?application.startuppath

For me (xl2002 and win98), I get:
C:\WINDOWS\Application Data\Microsoft\Excel\XLSTART

Kelly Lum wrote:

Dear Sir,

I am using ecxel 2000 and usually whsn saving a file, I
would put in a checkbox for preview.This is meant for
when searching files to see a small little picture on the
left corner to show u how the file l;ookss like. Can u
help1 Thank and awaiting yr favorble reply.Thank you once
agin.

Rgds
Kelly Lum

--

Dave Peterson



--

Dave Peterson