Does anyone know where this (or the equivalent) is in Excel 2007?

I am trying to import macros from a shared drive onto a computer so that they
are in my personal workbook each time I open Excel.  At this point, each time
I work with a file, I have to import the macros, making the process lengthy.  
Is there a way to import the macros from the ...

Hi, I have 6000 items listed in Excel
Some have the same name, If I use filter
the drop down list shows the list of different names
but how can I extract that list for use elsewhere

Excel hyperlinks are presumed to be aimed at other Excel files.  How can I
create a hyperlink in a cell, that takes the user to a project folder (so
that clicking the link opens the folder in a standard Windows Explorer
window)?

I have a drop down list of names, and I need the macro to find the name
selected within the workbook.  The names that are found would be on
individual sheets.  Could this be created?  Thank you.

Dear Sir,
I copied a list of reference number in HTML format from the MS Outlook and
paste it to Excel worksheet. After that I separated it into columns by using
Data > Text t to Columns function.

Hi there. Sometimes the formula in the cell dissapears eg
=890/1000
to just showing 0.89
I want to keep the formula in the cell. So I know where the value comes from

I have a Excell File which contains a "Locked for Viewing" Macro/Code.
I want the a group of users to update the same and send me back where they
can use the macro but restricted to view or edit in Macro....
Is this possible?

I have created a new template in Excel, and would like each new file based on
this template to be saved to a particular directory.  Any ideas?  Many thanks.

I’ve a big XL2003 table to which records are added every day or two, and a
couple of pivot tables analyse out what I want nicely, except …
I want counts and sums by month, where the column fields are the dates from
the records list. I want to group the dates into months. Following ...

Does anyone know of a way to use Autofill with a keyboard shortcut? That
would be excellent. I think it's one of the few remaining reasons I have to
use the mouse in excel.
E.g. you select a column of text using the shift and arrow keys, then want

I am setting up an excel sheet to export journal entries to Syspro,  the date
column must be DDMMYY, if i go through format cells and custom DDMMYY, when I
enter the date it changes it to its numeric value.   Syspro needs excel to
show the date as 220807.   Please help.  Many ...

I have cells  Jan-07  Feb-07...etc (J3:U3).
I need copy paste 8 times to destination cells J13:U13 -J23:U23 -
J33:U33...etc
Is it possible to solve with macro.

I would like to pull through total amounts from a number of worksheets to sit
at the main front navigation page.  Within the worksheets, the total figure
sits in column C:3.  Each worksheet has a different name - for example:
Castlehead.  Hope you can help!

My computer is one of those that decides not  to be able to instantly open
Excel files by double clicking a shortcut, etc. (if Excel isn't already
open).
I did the recommended fix which I obtained via this newsgroup. ie. add [rem