Re: $$Excel-Macros$$ Preventing to Delete based on condition

[Chandra Shekar]

Hello Paul,

Please find attached report and is it possible to disable Delete option for
all possible ways on particular condition

Regards,

Chandrashekar B

On Tue, Jul 31, 2018 at 5:03 PM, Paul Schreiner 
wrote:

> I'm not sure how you implemented the code.
> If it is installed properly, the user cannot SELECT the entire row to
> delete!
>
> The code goes in the "Thisworkbook" module.
> you can add the line:
>
> Debug.Assert False
>
> to have it pause to see if the macro is actually being called.
> *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 Monday, July 30, 2018 11:59 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>
> Hello Paul,
>
> Thanks for the reply. I tried this code but if user delete entire row it
> does not work.
>
> My requirement is code should not allow to delete entire row but it should
> allow to delete cells & it should allow to update cells/row.
>
> Regards,
>
> Chandru
>
> On Mon, Jul 30, 2018 at 6:20 PM, Paul Schreiner 
> wrote:
>
> I've done something like this before using a couple of different methods.
>
> It's really going to depend on what you're trying to "block".
>
> For instance, if you want to keep someone from deleting any of the rows
> 1-8, then
> you can use a SelectionChange event to test for selected rows in the 1-8
> range and the number of columns selected as greater than, say, 100...
> If the selection meets this criteria, simply change the selection and
> cancel the sub
>
> Like:
>
> Private Sub Workbook_SheetSelectionChange( ByVal Sh As Object, ByVal
> Target As Range)
>
>Dim Targ As Range
>For Each Targ In Target.Rows
> If ((Targ.Row >= 1) And (Targ.Row <= 8)) Then
> If (Target.Columns.Count > 100) Then
> Application.EnableEvents = False
> Cells(Targ.Row, "A").Select
> Application.EnableEvents = True
> Exit Sub
> End If
> End If
>Next Targ
> End Sub
>
> *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 Sunday, July 29, 2018 4:06 AM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>
> Hello,
>
> Is there any way to prevent from deletion based on condition but without
> using protecting sheet.
>
> For ex: Prevent user to delete row lesser than 8 but still he can able to
> edit it.
>
>
>
> 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 
>
> 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+unsubscribe@ 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

$$Excel-Macros$$ Performance Tester_Denver, CA_Long TERM

[Atulit Tripathi]

*Role –  Performance Tester*
*Location – **Denver, CO*
*Interview:  Phone and Skype*
*Job Type:  Contract (W2/C2C)*





*Note ::For H1b candidates need passport number or copy at time of
submission.  *

*LinkedIn is mandatory**. *

*Rate :: $55/hr on C2C *







*Details Job Description:*

•  Experience with Performance testing, tools and
engineering

•  Test Experience with containerization and tools
(Docker, Kubernetes).

•  Experience with scripted/interpreted languages such
as Perl, Ruby/JRuby, Lua (including Lua C API)

•  Experience with Go, Python, or other OO languages

•  Must have strong hands on experience in relational
and non-relational databases (Ideally NoSQL based systems like
Cassandra/MongoDB)

•  Experience with AWS testing (Amazon Web Services),
Tomcat and Linux environments

•  Ability to make decisions and solve problems while
working under pressure

•  Ability to prioritize and organize effectively

•  Knowledge of Git/GitHub or similar.

•  Excellent written and verbal communication skills.

•  Excellent analytical and troubleshooting abilities.





Regards,

Atulit Tripathi



*Next Level Business Services, Inc.*

*Staffing|Consulting|Outsourcing*



*Phone: **904-236-4873*

E-mail: *atulit.tripa...@nlbservices.com *
 |Web:www.nlbservices.com

Gtalk: *atulit.tripa...@nlbservices.com *

-- 
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$$ Services----Philadelphia, PA----6 Months

[kiran Toj]

Hi Friends,

Hope you are doing great,



I have an urgent requirement from one of my esteem client, I will
appreciate if you can have an eye on the below requirement and send me your
consultant updated profile ASAP.



*Services*

*Philadelphia, PA*

*6 Months*



Design and Develop Various networking features on Linux



*Job Description:*

1. 5+years of experience software development

2. Proficient in one of the Languages ( Unix Shell/Shell, Go,)

3. Understanding of Experience in networking protocols, TCP/IP,
IPSEC.IPVPN.MWAN, Firewall.

4. Good understanding of Linux Environment ( Ubuntu preferred)



Thank & Regards,

*Kiran*

Sierra Consulting, Inc.| Recruiter

*E-mail:* ki...@sierraconsult.com

*Office:* 224-310-5456 Ext: 122

-- 
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$$ Hiring for SQL Business Intelligence / EDW Developer - Atlanta, GA

[akshita mittal]

*Role  :   SQL Business Intelligence / EDW
Developer*

*Location   :   Atlanta, GA*

*Interview :   Phone and f2f*

*Duration  :   6+months*




Position Summary:

The Software Engineer, Business Intelligence / EDW Developer implements the
best practices in support of Business Intelligence practice. This role will
develop code for extracting data from source systems and loading to the
Enterprise Operation Data Store (ODS).  This role will also create
(Extract/Transform/Load) ETL for the purpose of loading to the Enterprise
Data Warehouse. This role is expected to develop and support data
visualizations and reports that have been developed using Power BI.  The
work will require understanding of Microsoft SQL Server based data
warehousing.
To be successful in this role:

· You demonstrate the ability to recognize and respond to customer
needs and you demonstrate commitment to customer service.

· You own the problems and requests assigned to you and resolve
issues to the customer’s satisfaction.

· You are a clear communicator and have the ability to communicate
appropriately to different audiences and organizational levels.

· You can examine situations, analyze possible causes and recommend
actions.

· You have the ability to prioritize your daily tasks and the
flexibility to monitor/adjust, as necessary.

· You enjoy collaborating with others and working as part of team
towards common visions and goals.
Responsibilities:

· Implement, support and maintain data process models, including
sourcing, loading, transformation and extraction.

· Implement business rules via stored procedures, middleware or
other technologies.

· Perform system analysis, data analysis or programming, using a
variety of computer languages and procedures.

· Create SSIS Packages and SQL for transforming and loading data
from source systems to the ODS and then to the EDW.

· Support and maintain ETL processes to accommodate changes in
source systems and new business user requirements.

· Create Dashboards and Reports based on a set of User
requirements, while adhering to Company and Industry standards.

· Define and capture metadata and rules associated with ETL
processes.
Skills:

· Strong customer service skills, including the ability to
communicate (both verbal and written) in a positive manner.

· Excellent telephone manner.

· Proven strong analytical ability as well as troubleshooting and
reasoning skills.

· Strong documentation skills.

· The ability to research, document and implement a solution.

· The ability to work collaboratively.
Qualifications:

· 5+ years using T-SQL or comparable SQL dialect such as PLSQL.

· 5+ years using SQL Server Integration Services for ETL / data
movement / integration

· 2+ years using SQL Server Reporting Services

· Experience using SQL Server Management Studio and Visual Studio
Data Tools

· Experience troubleshooting and monitoring SQL Agent job schedules.

· Experience working with Relational Data Warehouses where
star-schema / Kimball design practices have been adopted.

· Experience in Power BI development (on premise or cloud)

· Experience working in a Hybrid Cloud – On Premise landscape







*Regards , *

*Akshita  | ** KPG99,INC *


*3240 E State, St Ext |  Hamilton, NJ 08619  609-681-2602  ||
aksh...@kpgtech.com  *

-- 
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$$ Java Front-End---Basking Ridge, NJ--6+ Months

[kiran Toj]

Hi Friends,

Hope you are doing great,



I have an urgent requirement from one of my esteem client, I will
appreciate if you can have an eye on the below requirement and send me your
consultant updated profile ASAP.



*Java Front-End *

*Basking Ridge, NJ  *

*6+ Months *

*No Opt’s*

*F2F Interview*



*Must Have:*

· React.js

· Angular

· CSS3

· JavaScript



Thank & Regards,

*Kiran*

Sierra Consulting, Inc.| Recruiter

*E-mail:* ki...@sierraconsult.com

*Office:* 224-310-5456 Ext: 122

-- 
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$$ Looking for SAP Project Manager/SAP Solution Archtiect at Los Angeles Inter, CA

[Murugesan Subramani]

*Hi,*



Hope you are doing Good!!!



This is *Murugesan* from *Teamware Solutions!!!*



I am in search of a few genuine "* SAP Project Manager/SAP Solution
Archtiect*” for a contract with one of our client. Below is the brief
description about the role.



*Job Title  : SAP Project Manager/SAP Solution Archtiect*

*Location   : Los Angeles Inter,CA*

*Term: Long Term*

*Experience   : 10+ Yrs*



*Job Description:*

· SAP Solution Architect + Project Manager

· Design customer centric solutions according to the strategic
roadmap of Thales

· Translate the business architecture into "fit for purpose"
business models (capabilities)

· Ensure that the business requirements are reflected in the design
and that the appropriate business and technical services are reflected in
the overall architecture.

· Code Review





*If you are interested, Please fill the below details and send me your
Updated Resume*



*Skill Matrix*

*S. No*

*Technology (Skill)*

*Total YOE*

*Last used*

*1*





*2*







*3*







*4*







*5*









*Slot #*

*Day & Date*

*Morning(EST/PST/CST)*

*Evening(EST/PST/CST)*

*Slot 1*







*Slot 2*







*Slot 3*









*Candidate Details*

Candidate (Full) Name:

First Name:

Last Name:

Current Location (City, State): Relocation: Yes/No:



Cell # & Alternate #:



Date of Birth (MM/DD/):



E-mail ID:



Skype ID:



UG/PG, University, % & Year of Passing ():



Passport #:



Work Authorization with Expiry MM/YY:



Total Years of Experience & Onsite (US) Experience:



LinkedIn/Facebook/Twitter/Any Presence  of Social



Available to start the Project:



Reason for leaving current Project:



Vendor/Candidate Rate on C2C or W2 or 1099:



*Employer Details:* Name, Number & email ID




--



Thanks & Regards

Murugesan S | Talent Acquisition

Teamware solutions Inc | 2890, Carpenter Road, Suite# 2000, Ann Arbor, MI
48108

☎: (586) 580 4441 Ext: 215 | ✉: mur...@twsol.com

-- 
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$$ Java Front-End---Basking Ridge, NJ--6+ Months

[kiran Toj]

Hi Friends,

Hope you are doing great,



I have an urgent requirement from one of my esteem client, I will
appreciate if you can have an eye on the below requirement and send me your
consultant updated profile ASAP.



*Java Front-End *

*Basking Ridge, NJ  *

*6+ Months *

*Rate: $47/ hr on C2C*

*No OPT’s*



*Must Have:*

· React.js

· Angular

· CSS3

· JavaScript



Thank & Regards,

*Kiran*

Sierra Consulting, Inc.| Recruiter

*E-mail:* ki...@sierraconsult.com

*Office:* 224-310-5456 Ext: 122

-- 
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$$ Hiring for Sr. Back-End Node.js Developer (AWS) - Milwaukee, WI

[akshita mittal]

*Role :*  *Sr. Back-End Node.js Developer (AWS)*

*Duration :*  *6-12 month contract*

*Location  :* *Milwaukee, WI*

*Interview:  Phone, Skype*

*USC, GC,EAD-GC*



*LinkedIn required*



*Job description:*

· AWS, Lambda, Programming Nodejs (Back End), Typescript,  Aurora,
MySQL, DynamoDB

· 7-8 years of Experience required.









*Regards , *

*Akshita  | ** KPG99,INC *


*3240 E State, St Ext |  Hamilton, NJ 08619  609-681-2602  ||
aksh...@kpgtech.com  *

-- 
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$$ Looking for Technical Lead (Oracle ETL) at Pleasonton, CA

[Murugesan Subramani]

*Hi,*



Hope you are doing Good!!!



This is *Murugesan* from *Teamware Solutions!!!*



I am in search of a few genuine "*Technical Lead (Oracle ETL)*” for a
contract with one of our client. Below is the brief description about the
role.



*Job Title  : Technical Lead (Oracle ETL)*

*Location   : Pleasanton, CA*

*Term: Long Term*

*Experience   : 10+ Yrs*



*Job Description:*

· Lead techinical team on supporting TIM Applications (ATLAS, DML).

· Work closely with ASG team to provide level 3 support .

· Work on small enhancements as part of scheduled releases.

· Identify and resolve technical issues to ensure timely delivery
of the defect fixes/enhancementsRequirements collection

· Detail Design compilationCodingUnit Testing

· Stakeholders communication and coordination

· Excellent communication skills.

· Experience in supporting production applications

· Experience and ability to lead team of developers and working
with other teams in supporting applications

· Strong Development experience in Oracle, ETL(Informatica), SQL,
Unix/Linux platform.

· Perform system integration, Unit testing, test cases
writingRequirements collection

· Detail Design compilationCodingUnit TestingStakeholders
communication and coordination

· Excellent communication skills.

· Experience in supporting production applications

· Experience and ability to lead team of developers and working
with other teams in supporting applications





*If you are interested, Please fill the below details and send me your
Updated Resume*



*Skill Matrix*

*S. No*

*Technology (Skill)*

*Total YOE*

*Last used*

*1*





*2*







*3*







*4*







*5*









*Slot #*

*Day & Date*

*Morning(EST/PST/CST)*

*Evening(EST/PST/CST)*

*Slot 1*







*Slot 2*







*Slot 3*









*Candidate Details*

Candidate (Full) Name:

First Name:

Last Name:

Current Location (City, State): Relocation: Yes/No:



Cell # & Alternate #:



Date of Birth (MM/DD/):



E-mail ID:



Skype ID:



UG/PG, University, % & Year of Passing ():



Passport #:



Work Authorization with Expiry MM/YY:



Total Years of Experience & Onsite (US) Experience:



LinkedIn/Facebook/Twitter/Any Presence  of Social



Available to start the Project:



Reason for leaving current Project:



Vendor/Candidate Rate on C2C or W2 or 1099:



*Employer Details:* Name, Number & email ID




--




Thanks & Regards

Murugesan S | Talent Acquisition

Teamware solutions Inc | 2890, Carpenter Road, Suite# 2000, Ann Arbor, MI
48108

☎: (586) 580 4441 Ext: 215 | ✉: mur...@twsol.com

-- 
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$$ Hiring for SQL BI Developer - Gurnee, IL

[akshita mittal]

*Role :* *SQL BI Developer w/ Healthcare Exp. Duration: 6
months*

*Location  :* *Gurnee, IL*

*Duration  : 6+ months*

*Interview : Phone, F2F*

*USC,GC,EAD-GC*



*Job description:*



· healthcare background is a MUST

· has worked with a data scientist to analyze date (data analytics)

· Healthcare background understands HIPAA compliance and knowledge

· SSIS is a must with experience loading a data warehouse you know
this from the last position with 5 years of experience, we don t want
college grads or freshouts

· Analytics and reporting on this data ability to analyze and
understand the healthcare data









*Regards , *

*Akshita  | ** KPG99,INC *


*3240 E State, St Ext |  Hamilton, NJ 08619  609-681-2602  ||
aksh...@kpgtech.com  *

-- 
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$$ Looking for Mainframe DB2 Developer at Camden, DE

[Murugesan Subramani]

*Hi,*



Hope you are doing Good!!!



This is *Murugesan* from *Teamware Solutions!!!*



I am in search of a few genuine "* Mainframe DB2 Developer*” for a contract
with one of our client. Below is the brief description about the role.



*Job Title  : Mainframe DB2 Developer*

*Location   : Camden, DE*

*Term: Long Term*

*Experience   : 4-6 Yrs*



*Job Description:*

•  5+ years of work experience with mainframe technologies

•  Experience in DB2, COBOL, SPUFI, Stored Procs, SQL, JCL/Procs

•  Strong technical skills and experience in Web based application and
reporting technology

•  Experience in Handling and resolving Incidents based on priority and
severity.

•  Ability to write shell scripts and SQL for troubleshooting the job
abends and analyzing the incidents

•  Strong understanding of Database concepts.• Handle application
software related tickets escalated by customers, Technical support and
development Teams.

•  Participate in application maintenance and releases for production
and pre-production environments including vetting out test / validation
results, etc. with production development teams.

•  Support applications to meet SLAs.

•  Work with development team to create standard operating procedure
document for production environment.

•  Experience with various optimizing techniques in improving the
performance of the Jobs.

•  Experience working in Agile frame work and good understanding of
agile concepts.

•  Healthcare industry experiences a plus.





*If you are interested, Please fill the below details and send me your
Updated Resume*



*Skill Matrix*

*S. No*

*Technology (Skill)*

*Total YOE*

*Last used*

*1*

*Angular JS*





*2*







*3*







*4*







*5*









*Slot #*

*Day & Date*

*Morning(EST/PST/CST)*

*Evening(EST/PST/CST)*

*Slot 1*







*Slot 2*







*Slot 3*









*Candidate Details*

Candidate (Full) Name:

First Name:

Last Name:

Current Location (City, State): Relocation: Yes/No:



Cell # & Alternate #:



Date of Birth (MM/DD/):



E-mail ID:



Skype ID:



UG/PG, University, % & Year of Passing ():



Passport #:



Work Authorization with Expiry MM/YY:



Total Years of Experience & Onsite (US) Experience:



LinkedIn/Facebook/Twitter/Any Presence  of Social



Available to start the Project:



Reason for leaving current Project:



Vendor/Candidate Rate on C2C or W2 or 1099:



*Employer Details:* Name, Number & email ID




--

Please add hotl...@twsol.com to your distribution list.



Thanks & Regards

Murugesan S | Talent Acquisition

Teamware solutions Inc | 2890, Carpenter Road, Suite# 2000, Ann Arbor, MI
48108

☎: (586) 580 4441 Ext: 215 | ✉: mur...@twsol.com

-- 
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$$ Dell Boomi Developer----Westport CT----6+ Months

[kiran Toj]

Hi All,

Hope you are doing great,



This is Kiran from Sierra Consulting, Inc.



*Dell Boomi **Developer*

*Westport CT*

*6+ Months*



*Must Have Skills:*

Dell Boomi

Groovy Scripting

Java Scripting



*Detailed Job Description*

Integration requirements analysis, Roadmap definition, Architecture and
design consulting using Dell Boomi, APIGEE API.

Oversight of Interface developments.



*Top 3 responsibilities you would expect the Subcon to shoulder and execute*

Provide consultation to client on Integration API Roadmap Define the
Architecture principles and design guidelines Review the Interface API
designs prepared by offshore team





Thank & Regards,

*Kiran*

Sierra Consulting, Inc.| Recruiter

*E-mail: *ki...@sierraconsult.com

*Office:* 224-310-5456 Ext: 122

-- 
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$$ Urgent Requirement :: UI Developer with Angular experience :: VA

[RecruiterBoy USA]

Hello Vendors,



Good Morning,



please have a look at the job description mentioned below and share the
resume of the relevant candidates on "siddhart...@triveni.us"

*Title : UI Developer with Angular experience*

*Location : VA*

*Duration: 6+ Months*


*Required Qualifications:*

   - Undergraduate degree in applicable area of expertise or equivalent
   experience
   - full stack understanding and experience
   - Experience with Angular
   - Experience in JavaScript
   - Exposure to service driven, transactional, single page web applications



*Preferred Qualifications:*

   - HTML5
   - CSS3
   - Exposure to developing code in a Java environment



*Best Regards*



Sid

*Talent Acquisition Specialist*
*Triveni IT*

-- 
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$$ Hiring for Business Systems Analyst with Swift - Boston, MA

[akshita mittal]

*Title  :   Business Systems Analyst with
Swift*

*Duration  :   6+ months*

*Location  :   Boston, MA – must be able to work on
site*

*Interview:   Phone/ F2F*



*Only EAD-GC, GC and USC only.*



*MUST HAVE HIGHLIGHTED SKILLS*



*Job Description*

*Responsibilities:*

   - Determines systems specification based on business requirements,
   working with business end users to elicit proper solution design
   - Works to integrate/implement systems solutions working with
   development, quality, and release teams
   - Performs tests to ensure the quality of solution as a part of the
   delivery process
   - Produces systems delivery specifications, technical systems design,
   user procedure documents, training documents, and rollout procedures as
   applicable
   - Works to self-manage projects to budget/estimate and hit deadlines set
   forth by project leads/managers
   - Provides systems analysis support for production issues when needed
   - Works closely with Business groups and analyze clients requirements
   and write systems design documents.


*Qualifications:*

   - Bachelors degree in Computer Science or Management Information
   Systems, and/or equivalent work experience 4 to +6 years financial services
   experience a plus
   - Strong Financial domain knowledge required
   - Very Strong Analytical skills required
   - Project Management skills (Agile and water fall methodolgies) is
   required
   - SQL expeirence is required
   - SDLC Experience is a plus
   - 3+ SWIFT and other Messaging formats (XML,FpmL,FIX,SWIFTNET) required
   - SQL experience is a must
   - Programming skills like Java or Scripting languages a Plus
   - Excellent oral and written communication skills
   - Problem solving/analytical skills
   - Basic understanding and applies knowledge of the Project Life Cycle
   - Detailed oriented and out of the box analytical thinking a plus
   - Technology driven business skills
   - Experience in Water fall and Agile Methodologies is required
   - Experience in creating work flow diagrams ex: wire frames, UML, Visio
   - Experience with Application development Analysis is a plus
   - Ability to efficiently/effectively use Microsoft Word and Excel,
   Visio, Wire frames
   - Ability to use standard desktop tools effectively (Lotus Notes,
   Microsoft Office)



*Regards , *

*Akshita  | ** KPG99,INC *


*3240 E State, St Ext |  Hamilton, NJ 08619  609-681-2602  ||
aksh...@kpgtech.com  *

-- 
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$$ Hiring for Technical Business Analyst - Miami FL

[akshita mittal]

*Position   :Technical Business Analyst *

*Location  :Miami FL*

*Duration  :12+ Months*

*Interview :   Phone & Skype*

*Any Visa*



*Job Description :*

• Experience and deep understanding of *Chatbot
technologies*.

• Exceptional communication skills with an ability to
converse and influence effectively with engineers and executives. Must be
able to make effective presentations to a wide variety of audiences to
effectively drive alignment and understanding.

• Understanding the chatbot landscape, latest
technology and trends, and hands on experience utilizing chatbot with
capability to deliver customer facing experience.

• Proven track record of customer-centric, data-driven
problem solving that improves business performance.

• Ability to prioritize and balance multiple priorities
in a fast-paced environment.

• Excellent analytical and problem solving skills. Must
be able to identify root causes to problems and develop solutions to
eliminate recurrence.

• experience in *machine learning technology such as,
NLP, text analytics, chatbot, search or other ML technologies.*

• Partner with a high performing team of Business
Systems Analysts, Product Engineers, and Quality Engineers to build an
integrated chat bot experience.







*Regards , *

*Akshita  | ** KPG99,INC *


*3240 E State, St Ext |  Hamilton, NJ 08619  609-681-2602  ||
aksh...@kpgtech.com  *

-- 
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$$ Looking for Functional Analyst at New York, NY

[Murugesan Subramani]

*Hi,*



Hope you are doing Good!!!



This is *Murugesan* from *Teamware Solutions!!!*



I am in search of a few genuine "* Functional Analyst*” for a contract with
one of our client. Below is the brief description about the role.



*Job Title  : Functional Analyst*

*Location   : New York-2, NY*

*Term: Long Term*

*Experience   : 10+ Yrs*



*Job Description:*

· Data Lineage analysis across OTC Derivatives, Client Interviews
and Documentation

· In depth experience in Capital Markets, focused on Derivatives
and Regulatory Reporting.

· Must have worked in an BFS Organization in the past in the
Derivatives department.

· Should also have excellent communication skills as this project
involves extensive client interactions.

· Experience in Capital Markets, in other asset classes.



*If you are interested, Please fill the below details and send me your
Updated Resume*



*Skill Matrix*

*S. No*

*Technology (Skill)*

*Total YOE*

*Last used*

*1*

*Angular JS*





*2*







*3*







*4*







*5*









*Slot #*

*Day & Date*

*Morning(EST/PST/CST)*

*Evening(EST/PST/CST)*

*Slot 1*







*Slot 2*







*Slot 3*









*Candidate Details*

Candidate (Full) Name:

First Name:

Last Name:

Current Location (City, State): Relocation: Yes/No:



Cell # & Alternate #:



Date of Birth (MM/DD/):



E-mail ID:



Skype ID:



UG/PG, University, % & Year of Passing ():



Passport #:



Work Authorization with Expiry MM/YY:



Total Years of Experience & Onsite (US) Experience:



LinkedIn/Facebook/Twitter/Any Presence  of Social



Available to start the Project:



Reason for leaving current Project:



Vendor/Candidate Rate on C2C or W2 or 1099:



*Employer Details:* Name, Number & email ID




--

Please add hotl...@twsol.com to your distribution list.



Thanks & Regards

Murugesan S | Talent Acquisition

Teamware solutions Inc | 2890, Carpenter Road, Suite# 2000, Ann Arbor, MI
48108

☎: (586) 580 4441 Ext: 215 | ✉: mur...@twsol.com

-- 
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$$ Allocated :: IOS Applications Automation Tester with Java - San Francisco, California.

[vikash saraswat]

Greetings!



I trust this note finds you well. I am reaching you through this medium to
understand if you or you know anyone who is looking for a job opportunity
in IOS Applications Automation Tester with Java work based at San
Francisco, California..

Attaching below complete job description for your reference.



*NOTE : H-1B Candidates will work for this role**.*



*Role :* IOS Applications Automation Tester with Java

*Location :* San Francisco, California.

*Duration :* 6 + Months






*JOB DESCRIPTION*



IOS Applications Automation Tester.



· Java

· Selenium

· IOS App Testing on physical devices

· Web services automation using Java (Not using UI tools )

· *Appium* framework experience





Regards

*Vikash Saraswat*

*InfiCare* *Technologies*| 22375 Broderick Drive #225 Dulles VA 20166 |

Direct 703-652-4249 |  vik...@inficaretech.com

www.infiCareTech.com 

Servicing our clients since 2001MBE/ DBE Certified in VA, MD, PA, NJ,
NC, CA
IT Services * Application Development * Mobility Solutions

-- 
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$$ Do You Know New Google Rules and Info

[apextm Technical Multi-support]

Do You Know 
http://bit.ly/Call_Google_
Google Launch Its New Google Customer Service Phone Number to fix all 
issues And Problems Faced By Google User
Google Phone Number -> 1-888-678-5401
#google #technical #How #Funny #Movie #songs #Trends #Pranks

-- 
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$$ Preventing to Delete based on condition

[Paul Schreiner]

I'm not sure how you implemented the code.If it is installed properly, the user 
cannot SELECT the entire row to delete!
The code goes in the "Thisworkbook" module.you can add the line:
Debug.Assert False
to have it pause to see if the macro is actually being called. 
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 Monday, July 30, 2018 11:59 PM, Chandra Shekar 
 wrote:
 

 Hello Paul,
Thanks for the reply. I tried this code but if user delete entire row it does 
not work.
My requirement is code should not allow to delete entire row but it should 
allow to delete cells & it should allow to update cells/row.
Regards,
Chandru
On Mon, Jul 30, 2018 at 6:20 PM, Paul Schreiner  wrote:

I've done something like this before using a couple of different methods.
It's really going to depend on what you're trying to "block".
For instance, if you want to keep someone from deleting any of the rows 1-8, 
thenyou can use a SelectionChange event to test for selected rows in the 1-8 
range and the number of columns selected as greater than, say, 100...If the 
selection meets this criteria, simply change the selection and cancel the sub
Like:
Private Sub Workbook_SheetSelectionChange( ByVal Sh As Object, ByVal Target As 
Range)
   Dim Targ As Range
   For Each Targ In Target.Rows
    If ((Targ.Row >= 1) And (Targ.Row <= 8)) Then
    If (Target.Columns.Count > 100) Then
    Application.EnableEvents = False
    Cells(Targ.Row, "A").Select
    Application.EnableEvents = True
    Exit Sub
    End If
    End If
   Next TargEnd Sub
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 Sunday, July 29, 2018 4:06 AM, Chandra Shekar 
 wrote:
 

 Hello,
Is there any way to prevent from deletion based on condition but without using 
protecting sheet.
For ex: Prevent user to delete row lesser than 8 but still he can able to edit 
it.


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
 
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+unsubscribe@ 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+unsubscribe@ 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: