Re: $$Excel-Macros$$ Re: Hide to excel sheet

2013-11-28 Thread Ali Abbas
Thanks my dear thank you very much. On Nov 28, 2013 12:33 PM, "Ashish Kumar" wrote: > Hi Ali Abbas, > > Press ALT + F11 for Go to the VBA Application, then click on Tool, after > that click on VBA Project Properties, then click on protection and put your > passward and save the application. > > >

Re: $$Excel-Macros$$ Re: Hide to excel sheet

2013-11-28 Thread Ali Abbas
Thanks my dearcan we protect this hidden sheet with passward.? -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread t

Re: $$Excel-Macros$$ Re: Hide to excel sheet

2013-11-28 Thread Ashish Kumar
Hi Ali Abbas, Press ALT + F11 for Go to the VBA Application, then click on Tool, after that click on VBA Project Properties, then click on protection and put your passward and save the application. Thanks, Ashish On 28 November 2013 17:52, Ali Abbas wrote: > Thank you very much done love

Re: $$Excel-Macros$$ Re: Hide to excel sheet

2013-11-28 Thread Ali Abbas
Thank you very much done love dear, one more option please about thiscan we protect this hidden sheet with passward because of if any one know this option then he cannot open sheet without passward. On Nov 28, 2013 11:24 AM, "Shaikh Vasim" wrote: > Before every change can you select the w

Re: $$Excel-Macros$$ Re: Hide to excel sheet

2013-11-28 Thread Shaikh Vasim
If you finding it difficult, use Mr Negi's code.. Regards, On Thursday, November 28, 2013 5:29:00 PM UTC+5:30, ali abbas wrote: > > dear I am unable to select options from drop down list box. > On Nov 28, 2013 11:24 AM, "Shaikh Vasim" > > wrote: > >> Before every change can you select the worksh

Re: $$Excel-Macros$$ Re: Hide to excel sheet

2013-11-28 Thread Ali Abbas
dear I am unable to select options from drop down list box. On Nov 28, 2013 11:24 AM, "Shaikh Vasim" wrote: > Before every change can you select the worksheet from VBA project and then > choose your dropdown option. > > > Regards, > Vasim Shaikh > > On Thursday, November 28, 2013 4:35:25 PM U

Re: $$Excel-Macros$$ Re: Hide to excel sheet

2013-11-28 Thread Shaikh Vasim
Before every change can you select the worksheet from VBA project and then choose your dropdown option. Regards, Vasim Shaikh On Thursday, November 28, 2013 4:35:25 PM UTC+5:30, ali abbas wrote: > > my dear when I am use this option than a error comesunable to set > visible properties

Re: $$Excel-Macros$$ Re: Hide to excel sheet

2013-11-28 Thread Ali Abbas
my dear when I am use this option than a error comesunable to set visible properties of the worksheet class...now what I am doing plz help On Nov 28, 2013 10:57 AM, "Ali Abbas" wrote: > Thaks > On Nov 28, 2013 10:39 AM, "Shaikh Vasim" wrote: > >> Okies, >> >> >> Go to Developer - Visual Basi

Re: $$Excel-Macros$$ Re: Hide to excel sheet

2013-11-28 Thread Ali Abbas
Thaks On Nov 28, 2013 10:39 AM, "Shaikh Vasim" wrote: > Okies, > > > Go to Developer - Visual Basic - Select the sheet (you want ro hide from > the VBA project box) > in VBA editor - View - Properties window > in Properties window box - Visible (last option) and change it from > dropdown to optio

Re: $$Excel-Macros$$ Re: Hide to excel sheet

2013-11-28 Thread Ali Abbas
Thank You Very Much. On Nov 28, 2013 10:39 AM, "Shaikh Vasim" wrote: > Okies, > > > Go to Developer - Visual Basic - Select the sheet (you want ro hide from > the VBA project box) > in VBA editor - View - Properties window > in Properties window box - Visible (last option) and change it from > dr

$$Excel-Macros$$ Re: Hide to excel sheet

2013-11-28 Thread Shaikh Vasim
Okies, Go to Developer - Visual Basic - Select the sheet (you want ro hide from the VBA project box) in VBA editor - View - Properties window in Properties window box - Visible (last option) and change it from dropdown to option 2 - xlveryhidden. Regards > -- Are you =EXP(E:RT) or =NOT(EXP