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
acros@googlegroups.com > Subject: $$Excel-Macros$$ Re: Excel-Macros$$ Protect & hide Sheet > > Dear Kalyan, > > Attached spreadsheet has been solved as per your requirement(s). > > Note:- Going forward please mark the group as well while marking the query > email to me. By

$$Excel-Macros$$ Protect & hide Sheet

2010-09-03 Thread Kal xcel
Dear Experts, I need a help...How to protect & hide(Both together) a sheet? In attached file I need to "RSM" sheet will be password protected & hide, if anybody wants to unhide the sheet it will ask password, then it will open. Is it possible? Thanks in advance Kalyan --