Thanks Dave for your valuable comment but i am not able to achieve the
objective based on user input as explained in earlier mail.
Hope now you could provide the solution.
Regards,
C.G.Kumar
On Thu, Mar 18, 2010 at 7:43 AM, Dave Bonallack
wrote:
> Hi,
> I suggest you do all this with the mac
Hi all,
Required help in po tracking
On Thu, Mar 11, 2010 at 7:12 PM, Dilip Pandey wrote:
> Good and I also like the concept / funda of defined names.
>
> --
> Thanks & Regards,
>
> DILIP KUMAR PANDEY
> MBA-HR,B.Com(Hons),BCA
> Mobile: +91 9810929744
> dilipan..
Hi,
Use the following code line early in your macro:
A = Application.Caller
A will be the name of the button that called the macro.
You can call your buttons by special names, or use a Case statement to sort
through all the buttons you have.
Or you can get VBA to read the text on the button
Hello Everyone,
I request you all to share any tips or tricks that you have about MS
Excel in the group. It really helps.
The tip can be anything like formula, most used calculation, excel
trick, hidden truth or could be anything which you think can be done
in an easier way.
It can be any bug of
Thanks a lot
is this will work on excel 2007 as well ..???macro enable work book
is there any way to remove excel password to open workbook
Regards
Santosh Bahuguna
On Wed, Mar 17, 2010 at 5:56 AM, Yogesh wrote:
> Hi Roshan,
>
> Requesting you to read the reply which I have provided. You m
On Mar 17, 11:57 am, Paul Schreiner wrote:
> Can you send me the file?
No, sorry I can't. It's got confidential info. So, stupid question,
but just wanna make sure ... with Locking checked and Sheet Protection
on, those cells should definitely not be accepting user input, right?
--
I need help in breaking data links to other excel workbooks. The excel
workbook I am using (excel 2007) has links to other workbooks that can
been seen by going to Data -> Edit Links
One of the links listed here does not point to a valid workbook and I
would like to break the link to get rid of the
Hello,
I have several commandbar buttons that shall get the same OnAction
macro but with one parameter. This seems not to be possible. At the
moment I create one helper macro, which is unique to one button. This
helper macro calls then the real macro with the parameter. That works,
but I need this
Sorry, I'm stumped. If the cell's locked and the sheet's protected, that should
be that. Unless someone has figured out your sheet-protect password, and is
just toying with you...
If it's repeatable, post a copy of the workbook.
Regards - Dave.
> Date: Wed, 17 Mar 2010 06:52:07 -0700
> Subje
Hi,
I suggest you do all this with the macro recorder turned on, then use the
result as a starting point for your macro. You may even find that it needs no
changing at all.
Regards - Dave.
Date: Wed, 17 Mar 2010 16:24:44 +0530
Subject: $$Excel-Macros$$ Help urgently required..
From: kumar.
Can you send me the file?
I can open it in excel2007 and see if it works the same way.
It definitely sounds suspicious.
It would be nice to determine if it is file-related
or Excel-version related...
Paul
From: Jeff
To: MS EXCEL AND VBA MACROS
Sent: Wed, Marc
Amresh,
Please find the solution attached.
On Wed, Mar 17, 2010 at 4:30 PM, Amresh Maurya wrote:
> Examples are attached Also
>
> -- Forwarded message --
> From: Amresh Maurya
> Date: Wed, Mar 17, 2010 at 4:20 PM
> Subject: Urgent Need ur Help!!
> To: excel-macros@googlegroups.c
not sure but how do I re-format or move fields around without causing
the dates for the calendar to fail?
I am also trying to format the table of values (A3 to E5000) but
cannot.
On Mar 16, 8:31 pm, Deepak Rai wrote:
> Hi Mel,
>
> Please find the updated file which can be use with Excel 2003.
>
I don't think my question was clear. I understand how to lock or
unlock cells. The problem I'm having isn't with this. What I'm
seeing is that when the Worksheet Protection is on, and a cell is
Locked, that users are able to enter data into the cell anyway.
Has anyone seen this before or have a
Hi Roshan,
Requesting you to read the reply which I have provided. You may
download the file from the link mentioned in the mail.
Thanks & Regards,
Yogesh Kudva
On Mar 17, 3:00 pm, Roshan Mathew wrote:
> Pls forward us Hex Editor
>
>
>
>
>
> On Wed, Mar 17, 2010 at 12:45 PM, rf1234 rf1234 wro
sir how to install it
help pls
On Mar 16, 4:19 pm, Hemant K wrote:
> Hi,
>
> Find this add in this will help you to convert no to text
> first install this in and use it
> to use for example
> in Cell A1 you put no. 2000
> in Cell B1 put formula "=spellnumber(A1)"
> you will get result Rs. Two T
There are several ways to do this, but personally, I like to control what get
written to the file.
One approach would be to write a VBA macro that opens each of the files and
writes out EACH SHEET as a separate text file,
then... I believe there is a syntax for the DOS copy command (/b?) that I us
Examples are attached Also
-- Forwarded message --
From: Amresh Maurya
Date: Wed, Mar 17, 2010 at 4:20 PM
Subject: Urgent Need ur Help!!
To: excel-macros@googlegroups.com
Hi Friends,
can you help me on pivot table.
we have multiples name in columns. i want no of unique count
Hi Friends,
can you help me on pivot table.
we have multiples name in columns. i want no of unique count throw pivot
how i can do it..please help.
Regards
Amreh
--
--
Some important links for excel users:
1. Follo
Thank u very for support.
Regards,
Chandrabhan Singh
On Wed, Mar 17, 2010 at 3:37 PM, rf1234 rf1234 wrote:
> Hello Dear
> Following is the Steps,You can follow.
>
>
> '
Hello Dear
Following is the Steps,You can follow.
'
Open Vba Edito
Pls forward us Hex Editor
On Wed, Mar 17, 2010 at 12:45 PM, rf1234 rf1234 wrote:
> Hello Dear
> Please Have a look on attached doc file.
>
>
>
>
>
>
> Hope it Will Help
> Happy To Help
> :)
> Shyam
>
>
>
>
>
> On Tue, Mar 16, 2010 at 10:44 PM, Yogesh wrote:
>
>> H Yogesh,
>>
>> To crack the pas
Dear Harish
Really Helpful Topic.
Happy to Help
:)
Shyam
On Wed, Mar 17, 2010 at 1:28 PM, harish chandru
wrote:
> Hi All Hope this helps u all...
>
>
> http://office.microsoft.com/en-us/help/HA101491511033.aspx -> Interactive
> page, very useful
>
>
>
> Thanks
>
> Harish
>
> --
Dear All
Below is some defining of Dashboard.
‘’’
‘Dashboard is nothing but a sheet having automation for report generating.
‘’’
dashboard
‘
Hi,
if there is ten excel file in a folder, how to convert these files's into
one .txt file
One Team One Dream One Goal
Warm Regards,
Vikas Chauhan
E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com,
9911868518,
"We can't Spell S_ccess without U"
Life is Very beautiful !!!
¨`•.•´¨) Alway
Gaurav,
There is a great website called http://dashboardspy.com/. Check it
out! it gives lots of useful information to bring you up to speed on
building dashboards.
You should note in most cases, when it comes to dashboard, the simpler
it looks, the more difficult it is to build.
Good luck
Mich
Hello Dear,
You want to do multiple operation in one go.I think this post will help you
out little bit.
''
Hello Dear,
It depends on which type of security you have there.if u write a code for
protection.
ensure to forcely enabled macro before openning workbook.
On Wed, Mar 17, 2010 at 10:27 AM, Dave Bonallack
wrote:
> Hi,
> Each cell has to be locked for protection to have any effect.
> Sele
28 matches
Mail list logo
