Hello,
How to save attachments from Outlook(Particular Folder not under Inbox) to
local drive.
Regards,
Chandru
--
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
Hello Paul,
Thanks its working fine.
I have one more question is there any way we can prevent deleting rows
using VBA.
Regards,
Chandru
On Wed, Jul 25, 2018 at 5:42 PM, Paul Schreiner
wrote:
> You can use:
>
> =IF(AND(COUNTIFS(A:A,A2,B:B,"A")>0,COUNTIFS(A:A,A2,B:B,"B")>
> 0),"Yes","No")
>
You can use:
=IF(AND(COUNTIFS(A:A,A2,B:B,"A")>0,COUNTIFS(A:A,A2,B:B,"B")>0),"Yes","No")
Paul-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long
Hello,
Need formula which should check Column A and B For Ex: If CPI have both A &
B then its Yes. IF CPI has only A or B then it should be No.
Regards,
Chandru
--
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 t
HI Experts,
I am facing some challange in terms of understanding on of excel formula in
attached sheet.
Forumula is small and working fine and giving me result, but i am not able
to understand how its working.
SO kindly hlp mw understand the workability of this formula.
Formula :
=LOOKUP(1234,S
Hi Ankur,
Te date column should be updated automatically using today( formula.
And the Percentage value also need to updated in result sheet without
deleting the date history.
Regards,
Selvaraj M
On Sun, Jun 24, 2018 at 2:29 PM, ankur wrote:
>
> hi selva raj
>
> Source Sheet format is incom
hi selva raj
Source Sheet format is incomplete, missing date column
can you add more data to your sample file
*With Regards:*
*CMA** Ankur Pandey*
*B.Com (H), C.M.A *
* Mob: :- +919532513513*
*P* Please don't print this e-mail unless you really need it.
"This e-mail message may cont
Dear team,
I have attached my source excel sheet.
My workbook has the two sheet. One is Sourcesheet and another one is Result
sheet.
Requirements.
1. Need to copy and paste the value from source sheet to Result sheet once
i clicked the command button like attached sheet using VBA iteration
2.
hi Kaushik
use this one
=IF(C3>=VLOOKUP(D3,$F$13:$G$16,2,0),"yes","no")
excel sheet is attached for your reference
*With Regards:*
*CMA** Ankur Pandey*
*B.Com (H), C.M.A *
* Mob: :- +919532513513*
*P* Please don't print this e-mail unless you really need it.
"This e-mail message may
hope this attached fulfill your requirement.
*Regards,*
*For quick responds click here for Message *
On Sun, May 13, 2018 at 6:16 AM, KAUSHIK SAVLA
wrote:
> Hi All,
>
> Attached is the excel file which I am referring for help.
>
> Background: Daily basis there are some transactions getting
Hi All,
Attached is the excel file which I am referring for help.
Background: Daily basis there are some transactions getting created and are
either approved or pending or rejected. For the one's which are pending we
want to build a tracker which once data is dumped it will show whether
follow
Hi everyone,
Hope all is well, Can you please help on the below requirement.
*Requirement*: I need formula or VBA code which split to each code sequence
which is highlighted in yellow colour.
Eg: *Z020- Z026* = Z020 | Z021 | Z022 | Z023 | Z024 | Z025 | Z026
Code 1 2 3 4 5 6 7
Z005-Z006 Z005 Z
Hello,
I am trying to store my programming sources in excel. I would like to
create a style that recognizes a programming language and automatically
uses various colors for various programming objects.
In Notepad++ I can use some addons (styles?), so I was wondering if there
were something simi
You can use left or right function by converting number to text..
On Jan 6, 2018 21:26, "Deepu Raj" wrote:
> how to remove 1025 to 25 or 140 to 40 ie hundred and thousand removing
> using excel
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:O
how to remove 1025 to 25 or 140 to 40 ie hundred and thousand removing
using excel
--
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,
On Tue, 12/19/17, 'Julienne Schindler' via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Macro Help
To: excel-macros@googlegroups.com
Date: Tuesday, December 19, 201
On Mon, 12/18/17, V wrote:
Subject: Re: $$Excel-Macros$$ Excel Macro Help
To: "MS EXCEL AND VBA MACROS"
Date: Monday, December 18, 2017, 7:56 PM
Hi, do you know how
can I get using validations in Google Drive that change the
colo
Hi, do you know how can I get using validations in Google Drive that change
the color by codes.
El miércoles, 11 de octubre de 2017, 11:40:37 (UTC-5), GENIUS escribió:
>
> look at the attachment, I can do only this.
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
Respected Group Members
kindly download the sample file for detail.
Thanks & Regards
Sourabh
Contact Numbers: +91-94630-49202
Website:http://adhurapyaar.co.cc
--
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
look at the attachment, I can do only this.
--
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 titles. Poor thread titl
Dear Paul,
Thank you for your help.
I have attached both files in the mail.
In the master file I’ve highlighted some columns, if I update any value in
the master file automatically it’s need to update in the another attached
excel..
Thank you in advance.
On Mon, 09 Oct 2017 at 14:41, Paul Schre
sure.fairly easily done.Please provide sample files.
Paul-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
--
I have a master excel file (ABC.xls) which has n number of rows and
columns.
And also i have another excel file (DEF.xls) which has limited number of
same data from the master excel file (ABC.xls).
I need a macro code for if i update some values in the master excel file
(ABC.xls), automatica
Hi All
Reached out to seek help on my query as given below. Please
provide possible support.
Please find attached excel which has two tab
There is dropdown in Tab 1 - Chapter ID and Score
There are two columns in Tab 2 - Chapter ID and Score
When there is a match between Chapter ID from the dropd
Book your slot right now
https://www.itchat.in/microsoft-excel-vba-half-day-class/
RV
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
Hi Send details
On Friday, July 28, 2017, Rajan Verma wrote:
>
> [image: Inline image 1]
>
> --
> 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
[image: Inline image 1]
--
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 titles. Poor thread titles, like Please Help
Hi Experts, Can please anyone help me, i really needing for some help here.
On Sat, Jul 8, 2017 at 2:19 PM, Secret Shot wrote:
> Can anyone help me out here
>
> On Fri, Jul 7, 2017 at 11:12 PM, Secret Shot wrote:
>
>> Hi Folks,
>>
>> I really need your help, in a case i am working.
>>
>> I am g
Can anyone help me out here
On Fri, Jul 7, 2017 at 11:12 PM, Secret Shot wrote:
> Hi Folks,
>
> I really need your help, in a case i am working.
>
> I am getting data in a word file, and i need a macro which can open that
> word file using "Getfilename" option, then copy all data from that file
Hi Folks,
I really need your help, in a case i am working.
I am getting data in a word file, and i need a macro which can open that
word file using "Getfilename" option, then copy all data from that file and
paste into a excel sheet (Paste special).
I am trying below code but it is not working.
Hi,
I see your code and this spread sheet is great. I was wondering if there
was a way to stop the code from running when you select the whole row to
copy and paste it in a different line.
On Thursday, April 25, 2013 at 3:24:17 AM UTC-4, Abhishek Jain wrote:
>
> Please see the attached.
>
> F
I've Googled extensively and tested multiple options for more than 30 hours
over the last couple of weeks.
The results of my searches all LOOK reasonable, but all have failed to
function properly.
I have some SUSPICIONS as to why it's not working, but that doesn't lead me
to solutions.
Here's m
Hi Experts,
I have data of 1000 Emails, and text from body of the Emails is stored in a
cell. I want to do sentiment analysis to get customer inshght.
Can any one suggest any free Speech analysis tool of any Excel based Add-in.
Many Thanks
--
Pankaj Pandey
Bhopal
--
Are you =EXP(E:RT) or =N
Hi Vijay
In the Thisworkbook module, I added these two macros
Private Sub Workbook_BeforeClose(Cancel As Boolean)
HideAllSheets
End Sub
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
HideAllSheets
End Sub
and in the Module 1, I entered
Sub HideAllSheets()
Di
On Sat, 12/17/16, keisha.fry via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Saturday, December 17, 2016, 9:16 AM
On Sat, 12/17/16, spainy via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Saturday, December 17, 2016, 8:14 AM
On Sat, 12/17/16, spainy via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Saturday, December 17, 2016, 8:14 AM
On Sat, 12/17/16, julienneschindler via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Saturday, December 17, 2016, 7:17 AM
On Sat, 12/17/16, julienneschindler via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Saturday, December 17, 2016, 6:32 AM
On Sat, 12/17/16, mintaspriggs via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Saturday, December 17, 2016, 5:18 AM
On Sat, 12/17/16, margaretatolliver via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Saturday, December 17, 2016, 1:04 AM
On Sat, 12/17/16, margaretatolliver via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Saturday, December 17, 2016, 1:04 AM
On Fri, 12/16/16, spainy via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Friday, December 16, 2016, 6:08 PM
On
On Fri, 12/16/16, cronincarmelita via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Friday, December 16, 2016, 5:34 PM
On Fri, 12/16/16, libertystringer via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Friday, December 16, 2016, 4:56 PM
On Fri, 12/16/16, ashleypartridge via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Friday, December 16, 2016, 2:42 PM
On Fri, 12/16/16, mintaspriggs via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Friday, December 16, 2016, 2:14 PM
On Fri, 12/16/16, silvers.r via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Friday, December 16, 2016, 12:26 PM
On Fri, 12/16/16, cronincarmelita via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Friday, December 16, 2016, 6:03 AM
On Fri, 12/16/16, silvers.r via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Friday, December 16, 2016, 3:28 AM
On Fri, 12/16/16, mintaspriggs via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Friday, December 16, 2016, 1:40 AM
On Thu, 12/15/16, Vijayendra Rao wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Thursday, December 15, 2016, 5:12 PM
Hi
Paul,
Thank you very much
for your time, I tried both the
the people
> you can,As long as ever you can.” - John Wesley*--
> ---
>
>
> On Tuesday, December 13, 2016 1:45 AM, karleenbiggs via MS EXCEL AND VBA
> MACROS wrote:
>
>
>
> ------ ------
> On Tu
-- ---
On Tuesday, December 13, 2016 1:45 AM, karleenbiggs via MS EXCEL AND VBA
MACROS wrote:
------ ----------
On Tue, 12/13/16, ileanakeating via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$
the ways you
>> can,In all the places you can,At all the times you can,To all the people
>> you can,As long as ever you can.” - John Wesley*
>> -
>>
>>
>> On Tuesday, December 13, 2016 1:45 AM, karleenbiggs via MS EXCEL AN
On Wed, 12/14/16, silvers.r via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Wednesday, December 14, 2016, 2:23 PM
On Wed, 12/14/16, kenyattafreed via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Wednesday, December 14, 2016, 10:13 AM
On Wed, 12/14/16, mintaspriggs via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Wednesday, December 14, 2016, 10:53 AM
On Wed, 12/14/16, mintaspriggs via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Wednesday, December 14, 2016, 10:53 AM
On Wed, 12/14/16, kenyattafreed via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Wednesday, December 14, 2016, 10:13 AM
On Wed, 12/14/16, keisha.fry via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Wednesday, December 14, 2016, 10:05 AM
On Wed, 12/14/16, karleenbiggs via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Wednesday, December 14, 2016, 3:37 AM
On Wed, 12/14/16, cronincarmelita via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Wednesday, December 14, 2016, 3:14 AM
On Wed, 12/14/16, julienneschindler via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Wednesday, December 14, 2016, 2:51 AM
On Wed, 12/14/16, ileanakeating via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Wednesday, December 14, 2016, 12:37 AM
On Tue, 12/13/16, Paul Schreiner wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: "excel-macros@googlegroups.com"
Date: Tuesday, December 13, 2016, 2:11 PM
I'd
suggest changing the HideAllSheets macro to fir
On Tue, 12/13/16, Vijayendra Rao wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Tuesday, December 13, 2016, 2:54 PM
Thanks Paul for your
help, it is working fine. You saved my lot of
-------
> On Tue, 12/13/16, ileanakeating via MS EXCEL AND VBA MACROS <
> excel-macros@googlegroups.com> wrote:
>
> Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
> To: excel-macros@googlegroups.com
> Date: Tuesday, December 13
On Tue, 12/13/16, ileanakeating via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Tuesday, December 13, 2016, 8:27 AM
On Tue, 12/13/16, Vijayend
On Tue, 12/13/16, ileanakeating via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Tuesday, December 13, 2016, 8:27 AM
On Tue, 12/13/16, Vijayendra Rao wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Tuesday, December 13, 2016, 3:50 AM
Thanks Paul for quick
help, it fulfilled my most of the requirement
On Tue, 12/13/16, mintaspriggs via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Tuesday, December 13, 2016, 7:50 AM
On Tue, 12/13/16, margaretatolliver via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Tuesday, December 13, 2016, 4:07 AM
On Tue, 12/13/16, keisha.fry via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Tuesday, December 13, 2016, 3:56 AM
On Tue, 12/13/16, Vijayendra Rao wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Tuesday, December 13, 2016, 3:50 AM
Thanks
Paul for quick help, it fulfilled my most of the
requirement
ll the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -
>
>
> On Monday, December 12, 2016 7:50 AM, karleenbiggs via MS EXCEL AND VBA
> MACROS wrote:
>
>
>
> --------
> On Mon, 12/12/16, Vijayendra Rao
On Tue, 12/13/16, cronincarmelita via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Tuesday, December 13, 2016, 3:13 AM
On Tue, 12/13/16, julienneschindler via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Tuesday, December 13, 2016, 2:13 AM
On Tue, 12/13/16, mintaspriggs via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Tuesday, December 13, 2016, 2:04 AM
On Tue, 12/13/16, kenyattafreed via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Tuesday, December 13, 2016, 1:18 AM
On Tue, 12/13/16, kenyattafreed via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Tuesday, December 13, 2016, 1:18 AM
On Mon, 12/12/16, keisha.fry via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Monday, December 12, 2016, 11:44 PM
On Mon, 12/12/16, keisha.fry via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Monday, December 12, 2016, 11:44 PM
On Mon, 12/12/16, derrickandrew994 via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Monday, December 12, 2016, 11:05 PM
On Mon, 12/12/16, ashleypartridge via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Monday, December 12, 2016, 8:53 PM
On Mon, 12/12/16, julienneschindler via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Monday, December 12, 2016, 4:53 PM
On Mon, 12/12/16, Paul Schreiner wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: "excel-macros@googlegroups.com"
Date: Monday, December 12, 2016, 3:22 PM
There's
nothing that is "automatic
On Mon, 12/12/16, Paul Schreiner wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: "excel-macros@googlegroups.com"
Date: Monday, December 12, 2016, 3:22 PM
There's
nothing that is "automatic
On Mon, 12/12/16, Paul Schreiner wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: "excel-macros@googlegroups.com"
Date: Monday, December 12, 2016, 3:22 PM
There's
nothing that is "automatic
December 12, 2016 7:50 AM, karleenbiggs via MS EXCEL AND VBA
MACROS wrote:
On Mon, 12/12/16, Vijayendra Rao wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Monday, December 12, 2016, 2:43 PM
On Mon, 12/12/16, Vijayendra Rao wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Monday, December 12, 2016, 2:43 PM
Thanks Paul for quick
guidance.
This file is used by many people and
On Mon, 12/12/16, Paul Schreiner wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: "excel-macros@googlegroups.com"
Date: Monday, December 12, 2016, 2:16 PM
Just
as you created a macro to "unhide" the
Thanks Paul for quick guidance.
This file is used by many people and they are working without reading few
guidelines from first sheet. There may be chances of not using the
sheet_hide macro option by other user. Is there any macros which
automatically hide those sheets when close the file. Attache
Just as you created a macro to "unhide" the sheets, you need to create a macro
to hide them.
Additionally, you can create a BeforeSave event to check to see if the sheets
are displayed.Then execute your "Sheets_Hide" macro to hide the sheets before
saving (that way the sheets are always hidden b
Hi Experts,
I have created one excel file and except one sheet all sheets are hided. I
have added shape button in first sheet to unhide all the sheets with the
help of macro. When i worked and saved all sheets will be visible when I
opened again. Is it possible to remain hide those sheets after sa
No I don't have it. Please assists
On Tuesday, 8 November 2016, Paul Schreiner wrote:
> That's what I meant by:
>
> *You can modify it to also include changing the background highlighting as
> well.*
>
> Do you have the macro that changes the color and resets it?
> Simply add those statements in
That's what I meant by:
You can modify it to also include changing the background highlighting as well.
Do you have the macro that changes the color and resets it?Simply add those
statements in the appropriate place in the macro.
Paul-
“Do all the good you c
Thanks paul it working. But how to change the red colour to white when the
status is change to Passed. Can u include that on the code
--
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.faceb
Here is the file you request. thanks
On Sat, Nov 5, 2016 at 12:25 AM, Paul Schreiner
wrote:
> Yes, it could be done with an IF() function,
> but that would have to be duplicated and it would execute in each row
> whenever changes are made.
> Even if the changes were not done to the row involved.
Yes, it could be done with an IF() function,but that would have to be
duplicated and it would execute in each row whenever changes are made.Even if
the changes were not done to the row involved.
We can make a Change event so that whenever a cell is changed, it evaluates the
other cells in the sa
1 - 100 of 1590 matches
Mail list logo
