Maatangi,
your file has a link to a file called Database-formats11.xlsb that I don't
have, so I'm not sure if I can do much testing.
However, as far as the locked/protected cells go:Record a macro in which you
Protect the sheet (with a password) and making appropriate selections.then
unprotect
On Mon, 3/6/17, kenyattafreed via MS EXCEL AND VBA MACROS
<excel-macros@googlegroups.com> wrote:
Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel
2010 with Datavalidation & VBA
To: excel-macros@googlegroups
On Mon, 3/6/17, cronincarmelita via MS EXCEL AND VBA MACROS
<excel-macros@googlegroups.com> wrote:
Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel
2010 with Datavalidation & VBA
To: excel-macros@googlegroups
On Mon, 3/6/17, Maatangi M. Karthik <maata...@gmail.com> wrote:
Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel
2010 with Datavalidation & VBA
To: "MS EXCEL AND VBA MACROS" <excel-macros@googlegroup
On Fri, 3/3/17, margaretatolliver via MS EXCEL AND VBA MACROS
<excel-macros@googlegroups.com> wrote:
Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel
2010 with Datavalidation & VBA
To: excel-macros@googlegroups
On Fri, 3/3/17, keisha.fry via MS EXCEL AND VBA MACROS
<excel-macros@googlegroups.com> wrote:
Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel
2010 with Datavalidation & VBA
To: excel-macros@googlegroups.com
Da
First of all (last of all?):You can lock some cells and leave others available
for editing:- select all cells- right click on the selection - Select "Format
Cells"- select "Protection" tab- Make sure "Locked" is checked.- click "OK"
When the sheet is protected, all cells with this "locked"
On Fri, 3/3/17, Maatangi M. Karthik <maata...@gmail.com> wrote:
Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel
2010 with Datavalidation & VBA
To: "MS EXCEL AND VBA MACROS" <excel-macros@googlegroup
Hi there are a few more things I want from the excel.
1. There are some formulae in my excel sheet, I would like to convert them
to the backend so that the users cannot change them at any cost
2. There are some fields that affect these formulae in succession, that is,
two or three cell values
Thanks a lot for your response, Paul.
However, my issue got resolved with the help of another forum and was
resolved with the help of Combination of "On error resume next " and
"Application.EnableEvents=False / true" statements.
On Friday, 3 March 2017 01:02:22 UTC+5:30, Paul Schreiner wrote:
On Fri, 3/3/17, hopkinsruben865 via MS EXCEL AND VBA MACROS
<excel-macros@googlegroups.com> wrote:
Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel
2010 with Datavalidation & VBA
To: excel-macros@googlegroups
On Fri, 3/3/17, kenyattafreed via MS EXCEL AND VBA MACROS
<excel-macros@googlegroups.com> wrote:
Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel
2010 with Datavalidation & VBA
To: excel-macros@googlegroups
On Fri, 3/3/17, mintaspriggs via MS EXCEL AND VBA MACROS
<excel-macros@googlegroups.com> wrote:
Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel
2010 with Datavalidation & VBA
To: excel-macros@googlegroups
On Thu, 3/2/17, margaretatolliver via MS EXCEL AND VBA MACROS
<excel-macros@googlegroups.com> wrote:
Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel
2010 with Datavalidation & VBA
To: excel-macros@googlegroups
On Thu, 3/2/17, Paul Schreiner <schreiner_p...@att.net> wrote:
Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel
2010 with Datavalidation & VBA
To: "excel-macros@googlegroups.com" <excel-macros@
On Thu, 3/2/17, Paul Schreiner <schreiner_p...@att.net> wrote:
Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel
2010 with Datavalidation & VBA
To: "excel-macros@googlegroups.com" <excel-macros@
I deleted a row and received the "Type Mismatch" error.If you select "Debug",
you'll see that the offending line of code is: If Target.Value =
"OrderStatus" ThenPutting a "watch" on the Target variable, you'll see that it
isn't a single cell, but an array of cells!
When you change multiple
17 matches
Mail list logo