2003 Web toolbar - 2007/2010 equivalent

[VegasNath]

In xl2003, I used to copy the file address from the web toolbar for inserting links into email. I can't find the equivalent in 2007 or 2010, any ideas?

[HansV]

You can add the address box to the Quick Access Toolbar (QAT):
- Click the Office button / Select the File menu.
- Click Excel Options.
- Click Customize.
- Alternatively, click the dropdown arrow to the right of the QAT, and select More Commands... from the dropdown menu.
- Select "All Commands" from the "Choose commands from" dropdown.
- Scroll down and select "Document Location" in the list of commands.
- Click Add>> to add the command to the QAT.
- Click OK.

I don't know of a way to change the width of the box.

[VegasNath]

Thanks Hans.