Hi,
If you don't need any merged cells in your sheet, try putting these lines at
the beginning of your present code:
Cells.Select
With Selection
.MergeCells = False
End With
Range("A1").Select
Regards - Dave.
Date: Thu, 21 May 2009 23:11:30 +0530
From: prave
Hi,
Please share the macro u have..
Rgds,
Mahender Bisht
On Thu, May 21, 2009 at 11:11 PM, Praveen Khunte
wrote:
> Hi all
> How's everyone doing?
> I am novice to macro, I need a help from you guys. I hope it should be
> simple.*
> Present Scenario:* I have a macro which remove non-breaking s
Hi all
How's everyone doing?
I am novice to macro, I need a help from you guys. I hope it should be
simple.
Present Scenario: I have a macro which remove non-breaking space
from all the cells at once in the worksheet. (If anyone need, I can
share the code).
Usefulness of the Macro: When you co
Hi,
Sorry for attaching the password file. Please find here attached file for
help on how to work in excel with macros when it is s
On Thu, May 21, 2009 at 10:02 PM, Fabio Lemos wrote:
> Your file has password... please attach a file without password or send us
> the password.
>
> 2009/5/20 ank
HI
i want to make chart on data in excel its whole month data
i want to show to difference in timing so which chart will b suitable and
how cn i show the whole month data in chat
also in this i hv 4 columns
plz help me
plz mail me on another id
life_is_to_ch...@yahoo.co.in
Thanx
On Tue, May 19, 20
Option Explicit
Public Sub Protege(blnProt As Boolean)
Dim wstAux As Worksheet
For Each wstAux In ThisWorkbook.Worksheets
If blnProt Then
wstAux.Protect "PASSWORD"
Else
wstAux.Unprotect "PASSWORD"
End If
Next wstAux
End Sub
2009/5/21 su
Your file has password... please attach a file without password or send us
the password.
2009/5/20 ankur kochar
> Hi,
>
> I required a urgent help, I had an excel file which i want to work in
> shared, but in that file I am using macro with VB codes, I want help how to
> run the macro while work
WITH password or WITHOUT?
Depending on what options you want on the "protect", you can use:
'---
Option Explicit
Sub Protect_all()
Dim pw_ent, sht
pw_ent = "test"
For Each sht In ThisWorkbook.Sheets
ThisWorkbook.Sh
Hi All,
Can anyone provide the vba code to protect and unprotect all sheets in
excel.
Thanks & regards,
Suresh
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Exce
pls send a sample data sheet, will write the code there.
Paul
On Tue, May 19, 2009 at 11:02 PM, Vandana Vallam wrote:
> Dear Friends, Can someone help me to run a macro to calculate the sum of a
> cell across sheets...for Example
>
> Sheet 1 B2, Sheet 2 B2 and Sheet 3 B3 have some numbers...now
I'll try that out and get back to you.
For this example, creating multiple print jobs is trivial - but the
actual application involved many thousands of records that will be
printed, so it is a little more important to have separate print jobs
if possible.
On May 21, 3:45 am, Akhilesh Karna w
Note:
I have used the msgbox to test the process and show the status of the cell
if it is locked or not. You can remove the two lines for the msgbox , if it
is not required.
Regards,
Andy
On Thu, May 21, 2009 at 8:52 PM, Aindril De wrote:
> Dear Chande,
>
> Sorry for the confusion. Use the follo
Dear Chande,
Sorry for the confusion. Use the following code, It will work.
However there is a small drawback, you have to paste it in the sheet where
you want to activate it.
It will not work for any other sheet.
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Dim Txt As Stri
It's not possible using Excel conditional format,prior to xl2007.
Fabio L. Lemos
cel.: 8122-1206
Em 20/05/2009, às 13:42, Balla escreveu:
>
> thanks for link, but i want a way out without using macros
>
> On May 20, 6:48 pm, Norman May wrote:
>> Try the link below:
>>
>> http://www.mrexcel.c
Dear Andy,
Thx a lot for your kind help, I copied the code and pasted it in the
sheet...but i m unable to copy the cell content when i click one.
However being a novice, pls advice me if i need to do something to make that
macro run...
Thx $ Chande
On Thu, May 21, 2009 at 3:12 PM, Aindril De
Hello all,
I have some hyperlinks in Excel 2007 that point to an external
webpage. Rather than clicking the hyperlink, copying the data, etc.
I'd like to have a function/macro that would grab the contents of the
webpage based on the Hyperlink and populate another cell in the
spreadsheet with the
Dear Chande,
Please use the following code.
Sub putclp()
Dim Txt As String
If ActiveCell.Locked = True Then
MsgBox "this cell is locked"
End
Else
MsgBox "this cell is not locked"
ActiveCell.Copy
End If
End Sub
Please let me know if it helps.
Regards,
Andy
On Thu, May 21, 2009 at 1:54 PM, DOLLA
Hi,
See the attached file. I will help i think.
Regards
On Wed, May 20, 2009 at 10:40 AM, Deepak Rawat wrote:
> Hi all! i have attached a file, there is 5 fields in the file
> my requirement is, as i put city name in city field, then all the field
> should fill accordingly
> like as i put Mumb
As far as I know it will not be possible to achieve what you are trying to,
by a simple macro.
Other way, I can think of, is to print each invoice to a file (prn file)
using the following code. Then combine all the prn files into one(using
macro). Then sending the print command using shell_execute
Hai
Use the below formula in Summary Sheet B2 Cell:
=Sheet1!B2+Sheet2!B2+Sheet3!B2
Regards
On Tue, May 19, 2009 at 11:02 PM, Vandana Vallam wrote:
> Dear Friends, Can someone help me to run a macro to calculate the sum of a
> cell across sheets...for Example
>
> Sheet 1 B2, Sheet 2 B2 and Shee
20 matches
Mail list logo