$$Excel-Macros$$ Hide to excel sheet

2013-11-28 Thread Ali Abbas
Dear All, Hope all you well...plz tell me how can we hide excel sheet permanently which no buddy can un-hide, amd how can we hide xl sheet which no buddy can see with unhide option. Thank Tigarman007. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

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

2013-11-28 Thread Ravinder
Try this coding for hide the sheet. this will not allow to unhide from excel, only can unhide using vba coding Sub hidesheet_() ThisWorkbook.Sheets(1).Visible = xlVeryHidden End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ali Abbas Sent:

$$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

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 cv.va...@gmail.com 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

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

2013-11-28 Thread Ali Abbas
Thaks On Nov 28, 2013 10:39 AM, Shaikh Vasim cv.va...@gmail.com 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

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 tigarman...@gmail.com wrote: Thaks On Nov 28, 2013 10:39 AM, Shaikh Vasim cv.va...@gmail.com wrote: Okies, Go

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 of

RE: $$Excel-Macros$$ Want help in Automating IE application

2013-11-28 Thread Ravinder
Pls share file and website from where you are picking values if possible From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of anoop kumar Sent: Wednesday, November 27, 2013 6:56 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Want help in

RE: $$Excel-Macros$$ conditional formatting

2013-11-28 Thread Ravinder
pfa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rajesh Agarwal Sent: Wednesday, November 27, 2013 3:14 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ conditional formatting Dear Friend How to put conditional formatting in column

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 cv.va...@gmail.com 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

RE: $$Excel-Macros$$ Conditional Formatting

2013-11-28 Thread Ravinder
pfa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of anon Sent: Wednesday, November 27, 2013 2:45 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Conditional Formatting Attached. On Tuesday, 26 November 2013 18:06:00 UTC, ashish

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 cv.v...@gmail.com javascript: wrote: Before every change can

$$Excel-Macros$$ Need formula help

2013-11-28 Thread Dhaval Shah ( Ahd )
Want to choss Day only from date pls refer attachment Thanks Dhaval Shah -- 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

RE: $$Excel-Macros$$ Need formula help

2013-11-28 Thread Ravinder
=DAY(B2) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Dhaval Shah ( Ahd ) Sent: Thursday, November 28, 2013 5:44 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need formula help Want to choss Day only from date pls refer

RE: $$Excel-Macros$$ Need formula help

2013-11-28 Thread Dhaval Shah ( Ahd )
Thanks a lot Ravinder J From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ravinder Sent: Thursday, November 28, 2013 5:48 PM To: excel-macros@googlegroups.com Cc: Soum Subject: RE: $$Excel-Macros$$ Need formula help =DAY(B2) From:

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 cv.va...@gmail.com wrote: Before every change can

$$Excel-Macros$$ PowerPivate Utility

2013-11-28 Thread Tariq Aziz
Dear Team Member How to install PowerPivat Utility and run this utility in excel 2010. I all the steps one by one. Regards Tariq -- 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 @

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 tigarman...@gmail.com wrote: Thank you

$$Excel-Macros$$ Power Pivot

2013-11-28 Thread Sandeep Kumar Chhajer
Dear All, I have excel 2013, I want to know what enhanced feature it has from 2010 and I also want to know about power pivot and its uses. Thanks Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry® from Vodafone -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you

$$Excel-Macros$$ Re: PowerPivate Utility

2013-11-28 Thread Basole
hi, see this . http://social.technet.microsoft.com/wiki/contents/articles/714.powerpivot-install-the-powerpivot-add-in-for-excel.aspx Em quinta-feira, 28 de novembro de 2013 10h31min47s UTC-2, Tariq Aziz escreveu: Dear Team Member How to install PowerPivat Utility and run this

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

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 kumar.ashish...@gmail.com 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

$$Excel-Macros$$ To one digit calculation

2013-11-28 Thread Kongsambath PEN
Hi there, Hi, Please help me out in excel to find functions in the result cell following by calculation. https://lh3.googleusercontent.com/-8E38Bby5Sps/Updfvmh1JGI/Fdc/oAB4NwLwcQ8/s1600/Q1.png -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

$$Excel-Macros$$ Numbers in words with formula

2013-11-28 Thread excel lerner
Hi experts Please help me to convert numbers in to words in excel 2007.is there any formula to cinvert. Rs.1234 .56 Result is One thousand two hundred and thirty four and fifty six paisa thanks in advance -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ Comments

2013-11-28 Thread Shrinivas Shevde
Dear Ravindra Pankaj Marvelous job done ,really great. Can I get little more help With the current solution provided by both of you is working fine. Currently I am getting all the comments in single cel actually I want this comments in different lines Please find attached example Regards

Re: $$Excel-Macros$$ Numbers in words with formula

2013-11-28 Thread xlstime
read below link http://support.microsoft.com/kb/213360 . Enjoy Team XLS On Fri, Nov 29, 2013 at 9:27 AM, excel lerner exceller...@gmail.com wrote: Hi experts Please help me to convert numbers in to words in excel 2007.is there any formula to cinvert. Rs.1234

Re: $$Excel-Macros$$ To one digit calculation

2013-11-28 Thread xlstime
please share the sample sheet . Enjoy Team XLS On Thu, Nov 28, 2013 at 8:53 PM, Kongsambath PEN kongsambath@gmail.comwrote: Hi there, Hi, Please help me out in excel to find functions in the result cell following by calculation.