For the second, look at the workbook_open event. Activate the sheet in
that event.

http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy


"Sam" wrote in message
...
I am trying to set up a program to delete a record from one sheet and the
macro goes to the other sheets with the same record and deletes them
automatickly.
I also want to bring up the file to a specific sheet when it is first
opened.