Deactive/Freezing of yesterday Worksheet

Anirudh · 03-02-2008, 08:12 PM

I stuck up with a problem,

I am using a excel file having 31 sheets naming From 1-to-31 (eg. like 01-01-08,02-01-08 as on & on....).This sheets I am sharing with the other members of my team.
I want the worksheet automatically activate only for the current date,neither the worksheet should open for yesterday nor for next day.

And if somebody want to edit yesterday's sheet, the yesterday sheet only gets activated when I put the password.

Plz. provide some solution.

Many thanks in Adv.

Regards,

Anirudh

**Glaswegian** · 03-03-2008, 06:35 AM

The only solution I can think of would be using VB code in a Workbook Open Event. The code would run when the workbook was opened to hide all sheets except the current days sheet. Would that work for you?

Anirudh · 03-06-2008, 01:09 PM

Great thought process.

Thanks a lot.

03-02-2008, 08:12 PM	#1 (permalink)
Anirudh Registered User Join Date: Mar 2008 Location: Pune Posts: 5 OS: Window XP	Deactive/Freezing of yesterday Worksheet I stuck up with a problem, I am using a excel file having 31 sheets naming From 1-to-31 (eg. like 01-01-08,02-01-08 as on & on....).This sheets I am sharing with the other members of my team. I want the worksheet automatically activate only for the current date,neither the worksheet should open for yesterday nor for next day. And if somebody want to edit yesterday's sheet, the yesterday sheet only gets activated when I put the password. Plz. provide some solution. Many thanks in Adv. Regards, Anirudh Last edited by Anirudh; 03-02-2008 at 08:23 PM.

03-03-2008, 06:35 AM	#2 (permalink)
Glaswegian Moderator/ Rangemaster TSF Academy; Analyst, Security Team; Oor Wullie; TSF Surgeon and Resident Comic Join Date: Sep 2005 Location: Glasgow Posts: 25,419 OS: Win XP Pro SP3 / Win 7 Pro My System Blog Entries: 10	Re: Deactive/Freezing of yesterday Worksheet The only solution I can think of would be using VB code in a Workbook Open Event. The code would run when the workbook was opened to hide all sheets except the current days sheet. Would that work for you? __________________ Iain - Defender of the Haggis and all things Scottish. I don't help by PM - post in the Forums. PC Safety & Security::PC running a bit slow?::Donate::Photographers Corner

03-06-2008, 01:09 PM	#3 (permalink)
Anirudh Registered User Join Date: Mar 2008 Location: Pune Posts: 5 OS: Window XP	Re: Deactive/Freezing of yesterday Worksheet Great thought process. Thanks a lot.