You have dates spread across 30 sheets.

Are the dates random or is there some organization to them (each sheet is a
separate month - the first 12 sheets are 2003, dates start in row 2 of
column B, one per day as an example.

How does the front page fit into #1 and #2. In #2 where do you want to
enter the date

You have said jump to a sheet and show a "main" sheet with filled in data --
which is it.

Excel macro protection is what it is. You can certify your projects and
have the user accept the certification or they can lower there security
level.

--
Regards,
Tom Ogilvy

"Yonah Sudwerts" wrote in message
g.com...
I have a workbook that has about 30 sheets. Each line has a date in it (in
Column B).
The same date never (at least shouldn't) repeat itself.
I am interested in 2 different things (and that an additional add-on):
#1: When Excel opens, to get it to automatically, jump to Todays Date.
#2: To enable some kind of Search, that I can enter a date and it will
give
me the corresponding line.

#3: It would be nice if I can make a Front Page, that is shown when the
Excel file opens. Ideally, I would like it to fill in the information from
Today's Date, and then below it, to allow me to have the option to search
out a date (and then maybe also to search based on other (text-based
information -that would also not repeate itself) information in the
Workbook.

I'm not a total n00b, but I would like some direction.
Also, is there anyway to create this, and then distribute it, that people
will not have to deal with Security pop-up issues?

Thanks for any help,
Yoni