Re: $$Excel-Macros$$ Re: Excel-Macros$$ Protect & hide Sheet

2010-09-09 Thread Dilip Pandey
for the >>> >> owner/admin of the workbook. >>> >> >>> >> If you are learning this stuff, then pw is of no use to you rather you >>> >> should try creating this type of workbook on your own. :) >>> >> >>> >>

Re: $$Excel-Macros$$ Re: Excel-Macros$$ Protect & hide Sheet

2010-09-09 Thread Dilip Pandey
;> Best Regards, >> >> DILIPandey >> >> >> >> On 9/7/10, Vamsi Tatipamula >> >> wrote: >> >> > Thanks dilip for your explanation. >> >> > Can you share the password for that excel to open RSM sheet. >> >> &g

Re: $$Excel-Macros$$ Re: Excel-Macros$$ Protect & hide Sheet

2010-09-09 Thread N.Shivkumar
>> >> > Private Sub Workbook_Open() >> >> > Sheets("RSM").Visible = xlSheetVeryHidden >> >> > Sheets("Sheet1").Select >> >> > End Sub >> >> > >> >> > Best Regards, >> >> > DILIPandey &g

Re: $$Excel-Macros$$ Re: Excel-Macros$$ Protect & hide Sheet

2010-09-08 Thread Kal xcel
ssword for that excel to open RSM sheet. > >> > > >> > > >> > Regards, > >> > vamsi > >> > > >> > -Original Message- > >> > From: Dilip Pandey [mailto:dilipan...@gmail.com] > >> > Sent: Tuesday, September 07,

Re: $$Excel-Macros$$ Re: Excel-Macros$$ Protect & hide Sheet

2010-09-08 Thread Dilip Pandey
---Original Message----- >> > From: Dilip Pandey [mailto:dilipan...@gmail.com] >> > Sent: Tuesday, September 07, 2010 3:14 PM >> > To: Vamsi Tatipamula >> > Cc: excel-macros@googlegroups.com >> > Subject: Re: $$Excel-Macros$$ Re: Excel-Macros$$ Protect &a

Re: $$Excel-Macros$$ Re: Excel-Macros$$ Protect & hide Sheet

2010-09-08 Thread Kal xcel
Sent: Tuesday, September 07, 2010 3:14 PM > > To: Vamsi Tatipamula > > Cc: excel-macros@googlegroups.com > > Subject: Re: $$Excel-Macros$$ Re: Excel-Macros$$ Protect & hide Sheet > > > > Hi Vamsi, > > > > Thanks for your continuous interest. &g

Re: $$Excel-Macros$$ Re: Excel-Macros$$ Protect & hide Sheet

2010-09-07 Thread Dilip Pandey
t; Sent: Tuesday, September 07, 2010 3:14 PM > To: Vamsi Tatipamula > Cc: excel-macros@googlegroups.com > Subject: Re: $$Excel-Macros$$ Re: Excel-Macros$$ Protect & hide Sheet > > Hi Vamsi, > > Thanks for your continuous interest. > The VBA macro is working fine in my

Re: $$Excel-Macros$$ Re: Excel-Macros$$ Protect & hide Sheet

2010-09-07 Thread Dilip Pandey
amsi > > -Original Message- > From: Dilip Pandey [mailto:dilipan...@gmail.com] > Sent: Tuesday, September 07, 2010 10:45 AM > To: Vamsi Tatipamula > Cc: excel-macros@googlegroups.com > Subject: Re: $$Excel-Macros$$ Re: Excel-Macros$$ Protect & hide Sheet > >

Re: $$Excel-Macros$$ Re: Excel-Macros$$ Protect & hide Sheet

2010-09-06 Thread Dilip Pandey
, September 06, 2010 10:11 PM > To: Vamsi Tatipamula > Cc: excel-macros@googlegroups.com; kalx...@gmail.com > Subject: Re: $$Excel-Macros$$ Re: Excel-Macros$$ Protect & hide Sheet > > Hi Vamsi, > > Sure.. below is explanation:- > > Requirements were to unprotect and unhide a wor

Re: $$Excel-Macros$$ Re: Excel-Macros$$ Protect & hide Sheet

2010-09-06 Thread Dilip Pandey
Hi Vamsi, Sure.. below is explanation:- Requirements were to unprotect and unhide a worksheet only if a user enters correct password to do the same. What I have done I have instructed Excel to hide that side while opening (Worksheet Open Event) and given a button for a user to click if he/she wa