Try this code.
Sub unprotecsheet()
Dim wb As Workbook
Dim sh As Worksheet
Set wb = ThisWorkbook
For Each sh In wb.Sheets
sh.Unprotect AAABAABABBAR
Next
End Sub
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prabhakar S H
Sent:
=SUM(IF(FREQUENCY(IFERROR(--SUBSTITUTE((C2=$A$2:$A$12)*($B$2:$B$12),0,),
),IFERROR(--SUBSTITUTE((C2=$A$2:$A$12)*($B$2:$B$12),0,),)),1))
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Chandra Shekar
Sent: Tuesday, September 17, 2013 6:00 PM
To:
PFA
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rejeeb Abdulrahiman
Sent: Tuesday, September 17, 2013 10:06 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Check Box In Excel
Hi Friends,
In Excel 2010, I would like to create a
Hello,
Thanks for your replies. Formulas are working for one set of data but its
not working for other criterias I have attached new excel could you please
check it.
*Ashish - *I am trying to get count of unique records based on multi
conditions where I know what is Condition1 but I will be not
http://erlandsendata.no/?p=3653
On Wed, Sep 18, 2013 at 10:21 AM, Satheeshkumar Yadav
satheesh.arumu...@gmail.com wrote:
Hi Expert,
Any idea how to break the links in chart object in powerpoint through VBA
code.
--
Thanks regards
Satheeshkumar
--
Are you =EXP(E:RT) or
Hello,
I've got a shared workbook which is used by a number of people in my
office. It's got quite a lot of macros in it, but before I put it on the
network as a shared workbook it worked fine - it was quick to respond. Now
that I've made it a shared workbook it is horribly slow, both on
Hello Enrique Martin,
I have been attempted this query:
SELECT MIDASQ12013.COUNTRY, MIDASQ12013.ATC3_COD, Sum(MIDASQ12013.EUR_2008)
AS KEUR08, Sum(MIDASQ12013.EUR_2009) AS KEUR09, Sum(MIDASQ12013.EUR_2010)
AS KEUR10, Sum(MIDASQ12013.EUR_2011) AS KEUR11, Sum(MIDASQ12013.EUR_2012)
AS KEUR12,
I hope the below one works good to you... pls check
SELECT TOP 1 * FROM MIDASQ12013
WHERE MIDASQ12013.COUNTRY IN (SELECT TOP 20 MIDASQ12013.COUNTRY,
MIDASQ12013.ATC3_COD, Sum(MIDASQ12013.EUR_2008) AS KEUR08,
Sum(MIDASQ12013.EUR_2009) AS KEUR09, Sum(MIDASQ12013.EUR_2010) AS KEUR10,
Dear All,
As you all know if a .xlsm or .xlsb file is saved under .xlsx or non-macro
enabled file extension then in those files macros does not work or visible.
So i want to make a restriction in macro enabled files .xlsm or .xlsb that
they cannot be saved under non-macro enabled file extension.