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
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:
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
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
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
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
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
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
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
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
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
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
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
=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
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:
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
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 @
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
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
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
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
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
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
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
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
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
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.
27 matches
Mail list logo