Hi,
File by Mr Kantilal Badale is working as per your requirements. In
case you find problem in understanding how it is working please click
on any cell in column marked Sum of Sale 2 and right click. Select
"Value Field Setting.." > Select summarize by Sum and in Show Value as
tab select Running
Hi,
Try this.
Sub Macro6()
If ActiveSheet.ProtectContents = True Then ActiveSheet.Unprotect Else
ActiveSheet.Protect
End Sub
Regards - Dave.
> Date: Wed, 8 Dec 2010 20:49:58 +0530
> Subject: $$Excel-Macros$$ how to protect & unprotect the sheet with same
> button
> From: rajeshkainikk...@g
how to set my vba password through vba code. please help urgenly...
Thanks & Regards
Dhartikumar
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/ex
yes exactly
Thanks,
Chandrabhan Singh
On Tue, Dec 7, 2010 at 7:21 PM, Paul Schreiner wrote:
> Are you saying that you have an EXISTING Excel file,
> when you double-click, it doesn't open,
> but if you right-click, there is a menu that allows you to open the file?
>
>
> *From:* Born to Win
> *
It sounds like you have a Windows File Association problem.
Open "My Computer"
Select Tools-> Folder Options.
Select the File Types Tab.
Scroll down to the Excel File Extensions.
Select the file extension for Excel that you're having
trouble with (xls, xlsx, xlsm, xlsb)
Select the "Advanced" but
Check out the documentation on the FileSystem object.
once you create a FileSystemObject
(set fso = ...)
then you can use commands like:
set F = fso.getfile(filename)
then F.Name gives you the name by itself.
F.Path gives you the full name with path.
(or is it "F.FullName"?) I'd have to look at my
Hi Dave
The code is working well, Thank u very much
Regards
Rajesh kainikkara
On 12/9/10, Dave Bonallack wrote:
>
> Hi,
> Try this.
>
> Sub Macro6()
> If ActiveSheet.ProtectContents = True Then ActiveSheet.Unprotect Else
> ActiveSheet.Protect
> End Sub
>
> Regards - Dave.
>
>> Date: Wed, 8 De
Hi Daniel,
Its working well. Is it possible to the code will affect in specified
range("d5:d36)
Regards & Thanks
Rajesh Kainikkara
On 12/9/10, Daniel wrote:
> Hello,
> Here is an example if the setting can be done using row 1 :
>
> Private Sub Worksheet_Activate()
> Dim lastcolumn
> lastcolumn
Paul thanks, you helped me a ton. Basically this coupled with an
Outlook macro saved me 2 and a half hours a day in work. Thank you
very much. I can already see this being modified to help in other
tasks around the office!
Regards,
Jason
On Dec 3, 8:28 am, Paul Schreiner wrote:
> OK... here's wh
Hi Rajesh,
You're welcome.
Regards - Dave.
> Date: Thu, 9 Dec 2010 20:23:05 +0530
> Subject: Re: $$Excel-Macros$$ how to protect & unprotect the sheet with same
> button
> From: rajeshkainikk...@gmail.com
> To: excel-macros@googlegroups.com
>
> Hi Dave
>
> The code is working well, Thank u ve
After making several changes to the Ribbons and Quick Access Toolbars
in Outlook, we want to make a backup of our customizations. There is an
export button for this in the Options dialog but this only backs up the
customizations for the current item window and not all the item windows
which are av
hi group,
In the following vlookup code in macro, if any object is #N/A in the rng
then "*run time error 1004*"occurs. In such case, i want that it should
show a message as "*lookfor data is not in the range"*
help me how to put msg box if lookfor is not in the rng.
Sub vlookup()
Dim lookfor As
Dear Experts,
I am looking for a Salary Calculator for a Industrial Pvt Ltd Company based
in MIDC Navi Mumbai.
Would like all required calculations from Gross to Net monthly Salary.
(incld. PF etc)
Thanks
--
Vasi S D
vas...@gmail.com
--
---
13 matches
Mail list logo