Ans to Q2:

You can put the following inside an IF to Hide/Unhide the sheet based on
User name;
'To Hide
Worksheets("Sheet2").Visible = xlSheetVeryHidden
'To Unhide
Worksheets("Sheet2").Visible = xlSheetVisible

See http://support.microsoft.com/default.aspx/kb/161394 to get the code for
getting the user name

You will have to password protect your VBA project so that other users can
not change the code.

" wrote:

Hello,

I have 2 questions

1) I need help writing code wihin excel. I want to write code that
everytime I open the spreadsheet it takes me to the current date. For
example I have a workbook that I create every month that has multiple
sheets in it. Each sheet has the days of the month numbered as
follows 1, 2,3,4,5 etc. I want the sheet to open to the current day
when it opens. Example. if today is the 26th I want the sheet named
26 to be opened first. Excel by default will open to the last sheet
that was changed when the save was made. Please help.

2) Also, I would like to know how to hide a sheet within excel using
macros. The workbook has multiple sheets in it and I need a specific
sheet to always be hidden unless a specific user opens the workbook.
For example: if I open the workbook I want to be able to see the
sheet, but if another user opens the workbook the sheet will be hidden
but all other sheets will be visible. I'm not sure if it matters or
not but I need to give access to 4 users to be able to see this sheet
but all other users that open the workbook wont be able to see it.