Very Very thanx ravinder nagi for give me solution,again thankx
Date: Thu, 2 May 2013 23:18:01 -0700
From: ravi_colw...@yahoo.com
Subject: Re: $$Excel-Macros$$ please give suggestion...
To: excel-macros@googlegroups.com
here is the code and file attached with solution
Private Sub Workbook_SheetSe
try this see if it helps
Function file_exists(fl_path As String) As Boolean
If Dir(fl_path) <> "" And fl_path <> "" Then
file_exists = True
Else
file_exists = False
End If
End Function
Sub tests()
Dim finame As String
Dim wkb As Workbook
With Sheets("Feedback")
f
try this see if it helps
Sub Macro1()
With Range("e3:e16")
.Borders.LineStyle = xlContinuous
.BorderAround Weight:=xlMedium
End With
End Sub
On Fri, May 3, 2013 at 2:09 PM, Amit Desai (MERU)
wrote:
> In Simple I suggest to do borders in a blank cell & then copy the
> format. This way
Yes. It will take time.
The code and everything is already there. You just need to create the
userform. And you would good understanding if you create it yourself.
On Fri, May 3, 2013 at 5:35 PM, Prafull Jadhav wrote:
> Dear Abhishek Sir,
>
> I have just seen web site ..it it good one.
>
> I w
Dear Abhishek Sir,
I have just seen web site ..it it good one.
I will practice the same ...i know it will take time to understand the
whole funda as I am new for the same.
thanks a lot Sir
Reg,
Prafull Jadhav.
On Fri, May 3, 2013 at 5:14 PM, Abhishek Jain wrote:
> If you're willing to do
If you're willing to do some work by yourself, this is an excellent
example. Give it a try and tell me if you need help.
http://www.excel-vba-easy.com/vba-userform-excel-vba.html
On Fri, May 3, 2013 at 5:04 PM, Prafull Jadhav wrote:
> Dear Sir,
>
> Can i get example file so i can practice on i
Dear Sir,
Can i get example file so i can practice on it i want to learn macro
,form.which is related to excel VBA.
Regards,
Prafull Jadhav.
MIS exceutive.
On Fri, May 3, 2013 at 4:57 PM, Abhishek Jain wrote:
> Dear Prafull,
>
> In this example, no it does not get stored anywhere. Pan
Dear Prafull,
In this example, no it does not get stored anywhere. Pankaj had only asked
for restriction part. However, in his original form, yes, it should get
stored otherwise there is no purpose of having such forms.
Regards,
On Fri, May 3, 2013 at 4:39 PM, Prafull Jadhav wrote:
> Dear Pank
Dear Pankaj,abhishek Sir,
I have one query ..the infomration which we feed ..is it stored any
where...?
(I am new for Macro and VBA)
Regards,
prafull Jadhav.
On Thu, May 2, 2013 at 2:49 PM, pankaj gmail account
wrote:
> Thank You Abhishek Great!
>
> I was just looking for the same.
>
> in futu
Dear Nisha,
Thr r multiple sub function under subtotal function.
Like =subtotal(9,therange) will give u total sum of the range
2) =subtotal(1,therange) will give u average of the range
3) =subtotal(2,therange)will count the nonblank cell
and on..
Warm Regards,
Gawli Ani
In Simple I suggest to do borders in a blank cell & then copy the format. This
way you will get the only border (you do not have anything in cell so only
border will get copied.).
Best Regards,
Amit Desai
+91 98672 32534
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, F
Can you see check boxes below "Deny" Title on above screenshot provided by
Abhishek. Select a user from above list (here - Administrator, Guests etc)
in "Group or Username" category and check the boxes against the controls
mentioned in "Permissions for Administrators" Category. You can't restrict
a
Hi pravin...while saving the file you can see the tools option, you can
give password to open, read the file..
Prabhu R
On May 3, 2013 11:33 AM, "Pravin Gunjal" wrote:
> Hello,
>
> Is there anyway to give restriction to open a folder.
>
> Thanks,
> Pravin Gunjal
>
> --
> Are you =EXP(E:RT) or =N
you can use a macro for that.
Sub Border()
Range("a1").CurrentRegion.Borders.Value = 1
End Sub
And you have to change the cell address according to your requirement
On Wed, May 1, 2013 at 6:21 PM, L.K. Modi wrote:
> Dear Brothers
>
> I am facing problem in the matter of Format borders as i hav
Hi Anoop,
Could you explain more..
On Fri, May 3, 2013 at 12:40 PM, Anoop K Sharma wrote:
> You can restrict the first hand user (except administrator) by restricting
> him instead of giving full control.
>
>
>
> On Fri, May 3, 2013 at 12:27 PM, Pravin Gunjal wrote:
>
>> User Id will be the same
You can restrict the first hand user (except administrator) by restricting
him instead of giving full control.
On Fri, May 3, 2013 at 12:27 PM, Pravin Gunjal wrote:
> User Id will be the same...
>
> On Fri, May 3, 2013 at 11:45 AM, Anoop K Sharma wrote:
>
>> If you trying to restrict a folder
No prob bro...
On Fri, May 3, 2013 at 12:20 PM, Mathan wrote:
> Hi Anoop,
>
> Just wanted to let you know the result of implementation of your effort.
> It saved 35 Hours per month.. :-)
>
> Thanks again !
>
> Mathan
>
>
>
>
> On Thu, May 2, 2013 at 12:47 PM, Mathan wrote:
>
>> Hi Anoop,
18 matches
Mail list logo
