Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() "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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
cannot edit and save | Excel Discussion (Misc queries) | |||
cannot edit and save | Excel Discussion (Misc queries) | |||
How do I save a file in excel with a preview? | Excel Discussion (Misc queries) | |||
Save & Save As features in file menu of Excel | Excel Discussion (Misc queries) | |||
Missing "Save" and "Save As" functions | Excel Discussion (Misc queries) |