Happy Friday Everybody,
hope it is allowed to throw in a question here regarding a certain behavior
in Excel that I've just never seen fixed/improved. Ayush, maybe you or
anybody else here know. Just some trivia I'd like to understand as a geek.
I can't even remember what the first version of
Hi Pravin,
Yes you can do it.Please find the aatchment.
Regards
Priti verma
On Fri, Apr 26, 2013 at 7:15 PM, Pravin Gunjal wrote:
> Hi Preeti,
>
> Can we do "Unprotect All" also?
>
> But system should ask the password as usual for protect & unprotect.
>
> Regards
> Pravin.
>
>
> On Tue, Apr 2
I take it that the "Code" in your sample sheet it sheet is the "Given Name" you
refer to?
I would first:
record a macro in which you add a new sheet and change the name.
using this, there are several lines that you won't need:
-
Sheets("Sheet1").Select
Sheets.Add
She
Hi Kuldeep,
Please find attached...need u add more sheet name just change range name
.
Enjoy
Team XLS
On Fri, Apr 26, 2013 at 7:26 PM, Kuldeep Singh wrote:
> Hi Experts,
>
> I want to create sheets by given name (Via VBA). anyone please help me.
>
> Regards,
> Kuldee
*Thanks will try for the same*
*
*
*Regards,*
*Pravin Gunjal.*
-- Forwarded message --
From: xlstime
Date: Fri, Apr 26, 2013 at 7:26 PM
Subject: Re: $$Excel-Macros$$ Protect All Sheets Via VBA
To: excel-macros@googlegroups.com
Hi Pravin,
i have just add inputbox for value input
Hi Pravin,
i have just add inputbox for value input and replace sheet.protect
with sheet.unprotect for Unprotect all sheets
for protect all sheets
Sub ProtectAll()
Dim sheet As Worksheet
Dim myPassword As String
myPassword = InputBox("Enter password")
For Each sheet In ActiveWorkbook.Worksheet
Hi Experts,
I want to create sheets by given name (Via VBA). anyone please help me.
Regards,
Kuldeep Singh
Info Edge India Limited (naukri.com)
Phone.: +91-0120-4841100, Extn.: 2467, 9716615535
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e
Hi Preeti,
Can we do "Unprotect All" also?
But system should ask the password as usual for protect & unprotect.
Regards
Pravin.
On Tue, Apr 23, 2013 at 9:29 PM, priti verma wrote:
> Hi Kuldeep,
> Please use the following code
>
> Sub ProtectAll()
> Dim sheet As Worksheet
> Dim myPassword As S
The problem is with regard to a Windows Application "Instance".
Basically, when you open more than one workbook, the Excel "program" opens
once,
and each workbook is open in this single "instance" of Excel.
That's why, in earlier versions of Excel, you had a "window" menu selection
that listed
Your original statement is not entirely accurate.
Excel's Autofilter is techically applying a filter to ROWS based on the value
in
a COLUMN (or value of a cell in that row)
What it is actually doing is simply hiding any row that does not meet the
filter
criteria for a specific column.
What you
Hi Amar,
Please check below code for your requirement.
Public Sub cusPrintArea()
Dim myRange As String
myRange = Selection.Address
ActiveSheet.PageSetup.PrintArea = myRange
On Error Goto 1
1: Exit Sub
With ActiveSheet.PageSetup
.LeftHeader = ""
.CenterH
Can someone please answer?
Best Regards,
Amit Desai
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Amit Desai (MERU)
Sent: 22 April 2013 18:15
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Filter based on coulmns
Dear Friends,
In general w
Hello Anil,
I guess source data remained same in code
ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
"CABS_3CYL!R1C1:R147C24",
Version:=xlPivotTableVersion14).CreatePivotTable _
TableDestination:="Part!R1C1", TableName:="PivotTable2",
DefaultVersion _
Hi Experts,
I have a macro to compare two folders carrying Excel files and if I open
any other Excel file during the Macro Execution, the macro is getting
Stopped. Is it a normal behaviour of Excel or what can be the root cause of
this problem? Please advise me ASAP. Thanks
--
Thanks&Regards,
*S
14 matches
Mail list logo