default file locations Excel 2007

M

Machin8409

How can I change the default file location for inserting pictures? It
currently goes to My Pictures, which I do not want. The Excel Options
button/Advanced does not have the option to change this, like Word does.
 
R

Robert Flanagan

A simple cure is to right click in the white space in the open dialog for
the pictures default folder and select New, Shortcut. Select as the target
of the shortcut your desired folder. Name the shortcut AAA something so it
is on top. One advantage is you can add multiple shortcuts. And this
approach works in any file open/selection dialog.

Robert Flanagan
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clipart file locations 3
Trust Center - Trusted Locations 0
Access How to change default file save location in Access 2007 5
Default File>open folder 2
Worksheet direction in Microsoft Office Enterprise 2007 1
Default Folder locations 4
set Excel 2007 as default to save files in Excel 2003 .xls format 1
Excel Lotus 1-2-3 transition for Excel 2007 1

Top