Prev Previous Post   Next Post Next
  #1   Report Post  
Carolyn Crandall
 
Posts: n/a
Default Save in Preview



"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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
cannot edit and save jp Excel Discussion (Misc queries) 1 February 8th 05 05:12 PM
cannot edit and save jp Excel Discussion (Misc queries) 0 February 8th 05 03:27 AM
How do I save a file in excel with a preview? Jade Excel Discussion (Misc queries) 1 January 19th 05 08:29 PM
Save & Save As features in file menu of Excel Blue Excel Discussion (Misc queries) 9 December 27th 04 08:49 PM
Missing "Save" and "Save As" functions EMSchon Excel Discussion (Misc queries) 2 December 27th 04 08:01 PM


All times are GMT +1. The time now is 12:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"