$$Excel-Macros$$ Re: Weekend rates to place in range

['Sleek' via MS EXCEL AND VBA MACROS]

gosh what are all these romanian speakers talking in my thread , 
hope not passing incrimating spy messages !!!

On Saturday, April 29, 2017 at 4:59:17 PM UTC+3, Sleek wrote:
>
> Is there a simpler way to input weekend rates ?
> see my worksheet !!
> I used conditional formatting to highlight weekends but to input range of 
> dates seems like i have to do in quite a bit of typing !!
> I suspect probably using advanced filtering may help here !!
>
>
>
>
>
>

-- 
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, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Need :: Performance Engineer @ Deerfield, IL :: 6+ Months

[Vijay Narayana]

Hi,

We have *Immediate Interview Slots* for the below position with *Photon*.
Please let me know if you are interested.



*Role: Performance Engineer*

*Locations:   Deer field, IL*

*Duration: 6+ Months *



*Job Description:*

*Mandatory Skills :  Angular JS and Node JS*



· Experience in writing Angular , Node JS and React scripts.

· As a Performance Engineer you will be responsible for doing
pre-production performance testing.

· Ensure every major code or infrastructure change have been
certified by performance team under production like workload before
promoting it to production

· The performance team uses high-end integrated production like
infrastructure testing environment for following use cases

· To certify application code Releases and note any performance
impacts under production like workloads

· Validate fail-over/recovery scenario and measure any impact to
response times/interruption during execution of these scenario's

· Find opportunities to make application/infrastructure more
efficient

· Pinpointed the bottlenecks, memory leaks ahead of time to help
increase application performance.

· Designing test approaches and managing the end-to-end quality
life cycle of technology sponsored projects

· Design and Develop automated scripts using LoadRunner based on
business use cases for the application.

· Design scenario in LoadRunner to evaluate the performance of the
application

· Mentor junior team members

· Execute different kinds of performance tests like Load test,
stress, volume and endurance tests. Analyze the results using LoadRunner

· 6+ years professional experience as an Applications Developer
with development, deployment, and support of large-scale distributed
applications in a mission-critical production environment a plus

· Ability to work in a fast paced environment and multi-task

· Self-starter capability, ability to acquire new skills
autonomously

· Good communication skills

· Extensive technical problem-solving skills

· Experience in software quality assurance, defect tracking, and
test strategy development

· Must have experience preparing and presenting test results and
reports.

· Ability to translate business requirements into functional
requirements documentation.



· Bachelor / Master's Degree in Computer Science

· Experience in Angular , Node JS and React scripts







Thanks and Regards

*Vijay Valiveti*

Ph: 901-203-2883|| Email: vijay_valiv...@visionisys.com
*Visionisys Inc*

-- 
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, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ how to process parallel ranges with 'for each'

[Paul Schreiner]

how are you defining the corresponding cell?Is it the same cell in a different 
sheet?or is it the same "offset"That is:Range 1 is 3 rows x 3 columns beginning 
in cell A1 andRange 2 is 3 rows x 3 columns beginning in cell E1 
there's lots of ways to do it.In some cases, you can hard-code the row/column 
offsets in the loop.
Or, you could calculate the offset from the first cell of the rangeand use the 
offset in the second range.
if you can give me some real-life examples, I could try to throw something 
together.
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
- 

On Thursday, April 27, 2017 10:49 PM, Raymond Jerome 
 wrote:
 

 

I want to take 2 ranges, 1 dim each, can be 2 rows or 2 columns, but I need to 
take a cell from one range and do something with it's 'parallel' cell in the 
other range.
for example, something like a root mean square deviation. One column is data 
values, other column is expected values and the loop sums 
(data(i)-expect(i))^2...
here is how I understand doing something like this on one column or row, very 
simple, no error checking...

Function rms(ByVal Target As Range) As Double
'root mean squared. quadratic mean
Dim Cell As Range
Dim summand As Double
Dim tot As Integer
tot = 0
summand = 0#
For Each Cell In Target.Cells
    If IsNumeric(Cell) Then
    tot = tot + 1
    summand = summand + Cell ^ 2
    End If
Next Cell
rms = Math.Sqr(summand / tot)
End Function

what i do not understand or can't figure is how to do tghis kind of thing on 2 
ranges where a cell from one and a similar cell from the other are co 
processed. Perhaps using .address or .row or .col mixed and matched or split 
out... But is there some simpler way?
thank you-- 
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, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


   

-- 
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, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Hide & lock a formula in the cell

[Paul Schreiner]

The steps would be:1) Select all cells   Right-Click and select "Format Cells"  
 go to "Protection" tab and make sure "Locked" is selected.   Select "OK"2) 
Select all cells you want to be able to select/change   Right-click and select 
"Format Cells"   on "Protection" tab, DE-SELECT the "Locked" checkbox.   select 
"OK"3) Select "Protect Sheet" on Review tab.   Remove the checkbox that allows 
locked cells to be selected   But LEAVE the check for selecting UNLOCKED cells. 
  You can add a password or not (for testing, you can leave the password off)   
Note:Locked/Unlocked and Hidden/Unhidden only is enabled when the sheet is 
protected.otherwise, all cells are unlocked and shown.
hope this helps.-
“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
- 

On Monday, May 1, 2017 2:20 AM, Puneet Jain  wrote:
 

 Dear All
I request you to please help me in Excel sheet that how to hide & lock a 
formula in the cell, in the same way as done in Income tax excel form

-- 
With Warm Regards

Puneet Jain

Mobile-9899068873
Phone(O)-011-23456613
-- 
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, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


   

-- 
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, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Weekend rates to place in range

['Kenyatta Freed' via MS EXCEL AND VBA MACROS]

On Mon, 5/1/17, 'Karleen Biggs' via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ Weekend rates to place in range
 To: excel-macros@googlegroups.com
 Date: Monday, May 1, 2017, 2:03 PM
 
 
 
 On Sun, 4/30/17, sleek 
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Weekend
 rates to place in range
  To: "MS EXCEL AND VBA MACROS" 
  Cc: julienneschind...@yahoo.com
  Date: Sunday, April 30, 2017, 5:03 PM
  
  "We denote that it formulated in a
  historical context specifies the
 claims"Dear
  julienne, i have no idea what you
 wrote but i am satisfied
  with Ashish's solution.
  
  
  
  On Sunday, April 30, 2017 at
  11:56:52 AM UTC+3, Julienne Schindler
 wrote:
  
  --
  --
  
  On Sun, 4/30/17, sleek 
 wrote:
  
  
  
   Subject: Re: $$Excel-Macros$$
 Weekend
  rates to place in range
  
   To: "MS EXCEL AND VBA MACROS"
  
  
   Date: Sunday, April 30, 2017, 9:27
 AM
  
   
  
   Ok,You mean cell B3 rather, i am
 doing
  that
  
   now.Then for C column , i will
 modify the
  formula
  
   & place as such:
  
   =IF(OR(WEEKDAY(A3,2)=6,
  WEEKDAY(A3,2)=7),$M$4,180)
  
   Thanks for time saving tip Ashsih
  
   bhalara, I was trying advanced
 filter,
  conditional
  
   formatting, but i suppose when i do
 pose
  a problem here
  
   ,their is your way of solving it
 without
  me
  
   giving any hints/tips.
  
   
  
   
  
   
  
   On Sunday, April 30, 2017 at
  
   8:35:37 AM UTC+3, Ashish_Bhalara
 wrote:Hi
  Sleek,
  
   Use below condition in cell A3 to
 get
  output as
  
   per your requirement.
  
   =IF(OR(WEEKDAY(A3,2)=6,
  
   WEEKDAY(A3,2)=7),$L$4,150)
  
   
  
   RegardsAshish Bhalara
  
   On Sat,
  
   Apr 29, 2017 at 7:29 PM, 'Sleek'
  via MS EXCEL AND
  
   VBA MACROS 
  
   wrote:
  
   Is there a simpler way to input
 weekend
  rates
  
   ?see my worksheet !!I used
 conditional
  
   formatting to highlight weekends but
 to
  input range of dates
  
   seems like i have to do in quite a
 bit of
  typing
  
   !!I suspect probably using advanced
  filtering may
  
   help here !!
  
   
  
   
  
   
  
   
  
   
  
   
  
   
  
   
  
   -- 
  
   
  
   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, Urgent, Need
 Help,
  Formula Problem, Code
  
   Problem, and Need Advice will not
 get
  quick attention or may
  
   not be answered.
  
   
  
   2) Don't post a question in the
  thread of another
  
   member.
  
   
  
   3) Don't post questions regarding
  breaking or bypassing
  
   any security measure.
  
   
  
   4) Acknowledge the responses you
 receive,
  good or bad.
  
   
  
   5) Jobs posting is not allowed.
  
   
  
   6) Sharing copyrighted material and
 their
  links is not
  
   allowed.
  
   
  
    
  
   
  
   NOTE  : Don't ever post
 confidential
  data in a workbook.
  
   Forum owners and members are not
  responsible for any
  
   loss.
  
   
  
   --- 
  
   
  
   You received this message because
 you are
  subscribed to the
  
   Google Groups "MS EXCEL AND VBA
  MACROS" group.
  
   
  
   To unsubscribe from this group and
 stop
  receiving emails
  
   from it, send an email to
  excel-macros...@ googlegroups.com.
  
   
  
   To post to this group, send email to
 excel-...@googlegroups.com.
  
   
  
   Visit this group at https://groups.google.com/
  
   group/excel-macros.
  
   
  
   For more options, visit https://groups.google.com/d/
  
   optout.
  
   
  
   
  
   
  
   
  
   
  
   
  
   
  
   -- 
  
   
  
   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, Urgent, Need
 Help,
  Formula Problem, Code
  
   Problem, and Need Advice will not
 get
  quick attention or may
  
   not be answered.
  
   
  
   2) Don't post a question in the
  thread of another
  
   member.
  
   
  
   3) Don't post questions regarding
  breaking or bypassing
  
   any security measure.
  
   
  
   4) Acknowledge the responses you
 receive,
  good or bad.
  
   
  
   5) Jobs posting is not allowed.
  
   
  
   6) Sharing copyrighted material and
 their
  links is not
  
   allowed.
  
   
  
    
  
   
  
   NOTE  : Don't ever post
 confidential
  

Re: $$Excel-Macros$$ Weekend rates to place in range

['Karleen Biggs' via MS EXCEL AND VBA MACROS]

On Sun, 4/30/17, sleek  wrote:

 Subject: Re: $$Excel-Macros$$ Weekend rates to place in range
 To: "MS EXCEL AND VBA MACROS" 
 Cc: julienneschind...@yahoo.com
 Date: Sunday, April 30, 2017, 5:03 PM
 
 "We denote that it formulated in a
 historical context specifies the claims"Dear
 julienne, i have no idea what you wrote but i am satisfied
 with Ashish's solution.
 
 
 
 On Sunday, April 30, 2017 at
 11:56:52 AM UTC+3, Julienne Schindler wrote:
 
 --
 --
 
 On Sun, 4/30/17, sleek  wrote:
 
 
 
  Subject: Re: $$Excel-Macros$$ Weekend
 rates to place in range
 
  To: "MS EXCEL AND VBA MACROS"
 
 
  Date: Sunday, April 30, 2017, 9:27 AM
 
  
 
  Ok,You mean cell B3 rather, i am doing
 that
 
  now.Then for C column , i will modify the
 formula
 
  & place as such:
 
  =IF(OR(WEEKDAY(A3,2)=6,
 WEEKDAY(A3,2)=7),$M$4,180)
 
  Thanks for time saving tip Ashsih
 
  bhalara, I was trying advanced filter,
 conditional
 
  formatting, but i suppose when i do pose
 a problem here
 
  ,their is your way of solving it without
 me
 
  giving any hints/tips.
 
  
 
  
 
  
 
  On Sunday, April 30, 2017 at
 
  8:35:37 AM UTC+3, Ashish_Bhalara wrote:Hi
 Sleek,
 
  Use below condition in cell A3 to get
 output as
 
  per your requirement.
 
  =IF(OR(WEEKDAY(A3,2)=6,
 
  WEEKDAY(A3,2)=7),$L$4,150)
 
  
 
  RegardsAshish Bhalara
 
  On Sat,
 
  Apr 29, 2017 at 7:29 PM, 'Sleek'
 via MS EXCEL AND
 
  VBA MACROS 
 
  wrote:
 
  Is there a simpler way to input weekend
 rates
 
  ?see my worksheet !!I used conditional
 
  formatting to highlight weekends but to
 input range of dates
 
  seems like i have to do in quite a bit of
 typing
 
  !!I suspect probably using advanced
 filtering may
 
  help here !!
 
  
 
  
 
  
 
  
 
  
 
  
 
  
 
  
 
  -- 
 
  
 
  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, Urgent, Need Help,
 Formula Problem, Code
 
  Problem, and Need Advice will not get
 quick attention or may
 
  not be answered.
 
  
 
  2) Don't post a question in the
 thread of another
 
  member.
 
  
 
  3) Don't post questions regarding
 breaking or bypassing
 
  any security measure.
 
  
 
  4) Acknowledge the responses you receive,
 good or bad.
 
  
 
  5) Jobs posting is not allowed.
 
  
 
  6) Sharing copyrighted material and their
 links is not
 
  allowed.
 
  
 
   
 
  
 
  NOTE  : Don't ever post confidential
 data in a workbook.
 
  Forum owners and members are not
 responsible for any
 
  loss.
 
  
 
  --- 
 
  
 
  You received this message because you are
 subscribed to the
 
  Google Groups "MS EXCEL AND VBA
 MACROS" group.
 
  
 
  To unsubscribe from this group and stop
 receiving emails
 
  from it, send an email to
 excel-macros...@ googlegroups.com.
 
  
 
  To post to this group, send email to excel-...@googlegroups.com.
 
  
 
  Visit this group at https://groups.google.com/
 
  group/excel-macros.
 
  
 
  For more options, visit https://groups.google.com/d/
 
  optout.
 
  
 
  
 
  
 
  
 
  
 
  
 
  
 
  -- 
 
  
 
  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, Urgent, Need Help,
 Formula Problem, Code
 
  Problem, and Need Advice will not get
 quick attention or may
 
  not be answered.
 
  
 
  2) Don't post a question in the
 thread of another
 
  member.
 
  
 
  3) Don't post questions regarding
 breaking or bypassing
 
  any security measure.
 
  
 
  4) Acknowledge the responses you receive,
 good or bad.
 
  
 
  5) Jobs posting is not allowed.
 
  
 
  6) Sharing copyrighted material and their
 links is not
 
  allowed.
 
  
 
   
 
  
 
  NOTE  : Don't ever post confidential
 data in a workbook.
 
  Forum owners and members are not
 responsible for any
 
  loss.
 
  
 
  --- 
 
  
 
  You received this message because you are
 subscribed to the
 
  Google Groups "MS EXCEL AND VBA
 MACROS" group.
 
  
 
  To unsubscribe from this group and stop
 receiving emails
 
  from it, send an email to excel-macros...@
 googlegroups.com.
 
  
 
  To post to this group, send email to excel-...@googlegroups.com.
 
  
 
  Visit this group at https://groups.google.com/
 group/excel-macros.
 
  
 
  For more options, visit https://groups.google.com/d/
 optout.
 
  emarcam astfel ca  formulate intr-o
 conjunctura istorica specifica  

$$Excel-Macros$$ Hide & lock a formula in the cell

[Puneet Jain]

Dear All

I request you to please help me in Excel sheet that how to hide & lock a
formula in the cell, in the same way as done in Income tax excel form

-- 
With Warm Regards

Puneet Jain

Mobile-9899068873
Phone(O)-011-23456613

-- 
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, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.