How to create a custom numner format for IP addresses?

I want to create a program scheduling my restaurant staff using
excel.  I have set up my staffing levels and my hours at 15 minute
intervals.  I have tried to create a pop up list so I could select a
start and end time, but I'm not getting what I'm looking for.  When I

i have been using code cleaner for months to version my code modules.
it's becoming tedious since now i started importing the code modules
whenever i wanted to do a release.  any utility to easily import a set
of code modules, the import utility that comes with excel vba is

Calling the finest minds of this group:
I have a macro that is editing a word doc, that part is fine. The
problem is how to change the printer settings to use the colour
printer!

A newbie to the group and in no way an excel guru.
I need some help. I want to display a bar chart only for that data
that I already have. For example, the data I currently have is only
till end of January. When I do have data for February, I will fill

Help!!!
I am trying to change the data within my comment boxes dependant on the cell
value and if the source changes.
In my workbook I have 4 worksheets

I need to call a macro Macro1 written in A.xls from another macro Macro2
written in b.xls.
The file name "a.xls" is actually stored in column A on of b.xls, thus is in
a variable. Macro name Macro1 is defined and static.

Below are a couple of lines from some code I am running.  When the code
reaches the Autofill line, it runs the code (autofill takes place), but then
the code just stops (doesn't proceed to the next line of code) and reverts
back to the beginning of the sub.  I've tried stepping ...

I had a excel file with a custom vba function that worked fine.
I upgraded to 2007 and saved the file as a macro enabled workbook (.xlsm)
and cannot get the custom function to get called - it keeps displaying as a
#NAME? error.

I want to fill a ComboBox with items when I open the Workbook.
But I don't want to take the items from cells in the worksheet.
So I tried these lines:
Private Sub Workbook_Open()

Workbooks(NazivNovogLista).Worksheets("Specifikacija").Cells(PozicijaNaNovomList,k)=_
Workbooks(NazivOtvoreneDatoteke).Worksheets("Podaci").Cells(PozicijaNaListuKataloga,i)
This was working fine in Excel 2003. But In Excel 2007 I recived
message error :

My Current VBA for import test files are as follow, how can I select mutiple
files at one time instead of clicking one by one? Ctrl and Shift button does
not work in this. Thanks.
Sub Import()

Dear Chip and Zack,
I posted a reply yesterday using the google news interface, but it never
showed up???  Today the google interface seems to be seriously
disfunctional, so I'm using outlook express this time.

Can I enquire on the size of a range in an unopened worksheet?
The line below doesn't work:
 J = Workbooks("C:
\MyTables.XLS").Worksheets("cs_Tables").Range("CS_Names").Rows.Count

I have a client who would like for me to develop a spreadsheet that would
ideally consist of a successive set of forms - each one of which would have a
quetion.  What would happen is that the user would answer the question on the
first form and then based on their answer, the ...