Help with another (probably easy for you all) question. I use the code
below to add a pop-up menu that runs a macro.
   On Error Resume Next
   With Application

I wish to create a game-type programe whereby clicking a NEXT button opens up
a new screen.
The basic format envisaged is:
Three introductory animation screens (I think Powerpoint would satisfy this)

I'm trying to set up a macro that will pull up the default password box
for "protect sheet" and "unprotect sheet" command (tools->protection),
but I'm unable to macro it, and I'm not very proficient with VBA, can
someone help me out?

I need to place a date stamp on the row in column A, that is triggered
by any action on a row.
I need to place a time stamp on the row in column B, that is triggered
by any action on a row in column C.

In cell b2 i manually input the date as Feb 15th 2007
then in cell b40 (for example) I need the next days date
in cell B72 I need the next days date and so on.....................
basically B2 = Mondays date

I'm new to Excel and I want to do something that seems to be pretty
complicated (for me)!
I want to insert a clock onto a sheet and have it update in real time
when I start the program.  It also then needs to count down for a given

Appreciate very much if you can help.
I add a Spreadsheet control on my userform, and want to reference a
worksheet on the control. But got a "Type mismatch" error.
Set Sht = Me.Controls.Add("OWC10.Spreadsheet.10")

I haven't used "Evaluate" very much.  I saw an article on it and
decided to try so I didn't have to use formulas in my spreadsheet to
get things done.  But now I'm running into issues with it.
Hopefully someone can help me.

Here is a security question: what way can I restrict the access to SQL
Server 2005 database objects ?
I'm going to let some my users use some tables, views to create their own
MSQuery queries to retrieve data from SQLServer, but not all ones! (I have

I am programatically creating a workbook. I copy some worksheets over
and need to give a name to a range of cells so another sheet can
reference them. I used this code:
   Names.Add Name:=RangeName, RefersTo:=ReferString, Visible:=True

I hope I can explain this so everyone can understand.  There is a
website that lists Japanese residential real estate data
(www.chintai.net), that I was previously able to use Excel's web
query function to go to all the pages, and download the data I wanted.

Is there a way to extract/screen scrape data [into an excel
spreadsheet] from a website that requires a login? I'm trying to cut
down on all the manual work my team does every day and this seems to be
the most logical way to do it.

COMSYS is seeking a Business Objects Xcelsius Developer for a very
important project in Washington, DC.
We are seeking a strong resource to build and deploy a prototype
dashboard to measure and validate service levels against customer

I have a macro that appends values from Sheet14 to the end of a list of data
on Sheet13, then sorts the entire group in alpha order. My first problem is
that the range (rng) isn't updated- it refers to Prescreenlist which is a
Steve Bullen auto-expanding range, but I'm guessing ...

I have following problem:
I have one file test.xls and i would like to downloading to this file
some of the date from diferent files
Each next file will have names ( next number ) .xls  for example :