Hello,
Is there anyway to give restriction to open a folder.
Thanks,
Pravin Gunjal
--
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
There is an inbuilt feature in Windows like briefcase or something but I
didn't use it. Also there are bunch of third party software for it. The one
I prefer is Folder Lock.
On Fri, May 3, 2013 at 11:32 AM, Pravin Gunjal isk1...@gmail.com wrote:
Hello,
Is there anyway to give restriction to
If you trying to restrict a folder by supplying a password that can only be
possible with any foreign application.
But if you trying to restrict a folder to a person logged on using
different user id on same or another machine connected to each other that
can be done by changing properties of a
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 mathan4s...@gmail.com wrote:
Hi Anoop,
It's working fine. Thanks a lot ! :-)
Your dedication is much
Thanks.
On Fri, May 3, 2013 at 11:43 AM, Abhishek Jain abhishek@gmail.comwrote:
There is an inbuilt feature in Windows like briefcase or something but I
didn't use it. Also there are bunch of third party software for it. The one
I prefer is Folder Lock.
On Fri, May 3, 2013 at 11:32 AM,
User Id will be the same...
On Fri, May 3, 2013 at 11:45 AM, Anoop K Sharma aks.sharm...@gmail.comwrote:
If you trying to restrict a folder by supplying a password that can only
be possible with any foreign application.
But if you trying to restrict a folder to a person logged on using
No prob bro...
On Fri, May 3, 2013 at 12:20 PM, Mathan mathan4s...@gmail.com 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
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 isk1...@gmail.com wrote:
User Id will be the same...
On Fri, May 3, 2013 at 11:45 AM, Anoop K Sharma aks.sharm...@gmail.comwrote:
Hi Anoop,
Could you explain more..
On Fri, May 3, 2013 at 12:40 PM, Anoop K Sharma aks.sharm...@gmail.comwrote:
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 isk1...@gmail.com
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 ca.mod...@gmail.com wrote:
Dear Brothers
I am facing problem in the matter of Format
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 isk1...@gmail.com wrote:
Hello,
Is there anyway to give restriction to open a folder.
Thanks,
Pravin Gunjal
--
Are you
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 user
--
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,
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]
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
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
pankaji...@gmail.comwrote:
Thank You Abhishek Great!
I was just looking for the
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
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 abhishek@gmail.comwrote:
Dear Prafull,
In this example, no it does not get
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 prafulltjad...@gmail.comwrote:
Dear Sir,
Can i get example file
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 abhishek@gmail.comwrote:
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 prafulltjad...@gmail.comwrote:
Dear Abhishek Sir,
I have just seen web site
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)
amit.de...@merucabs.comwrote:
In Simple I suggest to do borders in a blank cell then copy
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)
finame =
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
24 matches
Mail list logo