When workbook open it show the sheet have today date

Hi RR

Try this

Please Login or Register  to view this content.

It needs to be copied in to the Workbook Open Event

Hope it helps

Hi RR

Try the below.

You will have to add your password inside the speech marks.

Downside of this is your passwords are on view if users know how to get at code :-(

Please Login or Register  to view this content.

Hi Hawkwind,

Somthing I am not doing right here, if i put my password in it the it give a error the password I supply is not correct. if I unlock all the sheet and paste the code with password "123" in speech marks then it work fine but if I try to unlock the sheet with password "123" then I get message my password is not right. then I am unable to unlock this sheet.

if i paste this code as it show then what will be my password ?

Apologies RR

I missed the two dots :

Please see below

Please Login or Register  to view this content.

Hope this helps and sorry for the missing bits :-)

Hi Hawkwind,

Thanks for your help this code work fine, do not say sorry mistake happen.
do we able to change this code to work if the workbook only have tab 1 to 31 and vba look for the tab name match with today date and open up that sheet. the code above insert the date in cell a1 but if I do not want to put the date anywhere on my sheet. I have few other workbook that I want to change it when they open it show the tab that equal to today date. I know i can chose the code above and may be use the cell a65000 but I want vba that only look for tab name.

Thanks
RR

Hi RR

I misunderstood your request.

Please Login or Register  to view this content.

The above code will select the sheet name 1 to 31 based on the day opened e.g. 24/07/2013 would mean sheet no 24 would be opened.
The removed code only added the Date value to the sheet as I thought that was what you wanted. The password part was required to add the date value so this is also not needed.

Cheers
Hawkwind

Hi Hawkwind,
It works the way I want to see.
Thank you for your time and help.
RR