unlock all cells in column A
instanciate a checkbox in cell A1 (CheckBox1)
create a conditional formatting for B1:C1
put the thos vba code to Sheet1 Module
Private Sub CheckBox1_Click()
Me.Unprotect
If CheckBox1 = False Then
Range("B1:C1").Locked = True
Else
Range("B1:C1").Lo
Hi,
How to update the particular row in an excel when some data is
modified in another excel.
Example:
The book1 contains the master file and book2 is the sub file. When the
user updates/modified some records in Book2, it should refelect in
book1 for that particular record. Is it possible to do w
I would like to add a checkbox in column A for an Excel spreadsheet.
When the checkbox is checked, you can type in columns B, C and D. If
it is unchecked, the cells are locked.
Ideally, I would like columns B, C and D to be grey if they are
unchecked.
How would I go about doing this?
--
try to use this UDF and see if it helps..
Function GetNumbers(S As String, Index As Integer)
'
' siti Vi / jakarta, 30-08-2009
'
Dim ArrN(), i%, tmp$, n%, t$, t2$
S = Trim(S) & "|"
For i% = 1 To Len(S) - 1
t$
correction on the last command.
Sub CanSomeOneHelp()
Dim RgDest As Range
With Workbooks("Anodize.xls").Sheets(1)
.Unprotect
Set RgDest = .Cells(1).CurrentRegion
End With
Set RgDest = RgDest.Cells(RgDest.Rows.Count + 1, 1)
Workbooks("Quote.xls").Sheets(1).Cells(1).Curre
assuming that the both workbooks are openned
Sub CanSomeOneHelp()
Dim RgDest As Range
With Workbooks("Anodize.xls").Sheets(1)
.Unprotect
Set RgDest = .Cells(1).CurrentRegion
End With
Set RgDest = RgDest.Cells(RgDest.Rows.Count + 1, 1)
Workbooks("Quote.xls").Sheets(1).C
if you should also indicate if he returns to normal or keep
the FullScreen
2011/4/15 Rajesh K R
> Hi Experts,
>
> I gave the following code to get the full screen view, if it is only
> applicable to that particular workbook how can i change it.
>
>
> Private Sub Workbook_Open()
> Applicati
Please attach file
to better understand !!
2011/4/19 C.G.Kumar
> No file found.
>
>
> On Mon, Apr 18, 2011 at 7:31 PM, Daniel wrote:
>
>> Hi,
>>
>> Please, attach file ;-)
>>
>> Daniel
>>
>>
>>
>> *De :* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *De la part de
add this macro
Private Sub Full_ScreenClose()
' Set Microsoft Excel to Full Screen Display.
Application.DisplayFullScreen = False
End Sub
2011/4/15 Rajesh K R
> Hi Experts,
>
> I gave the following code to get the full screen view, if it is only
> applicable to that par
see if it helps
On Tue, Apr 19, 2011 at 7:14 PM, karan kanuga wrote:
> Hi,
>
> Can any1 pls let me know how do i separate the text and nos in a
> given sentence. PFA the sheet where i need to separate the nos and text.
>
> Thanks.
>
> --
>
> --
paste the macro in worksheet change event . if your search criteria is in
sheet 1 the paste the macro in Worksheet_Change even tof sheet 1
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row = 3 And Target.Column = 5 Then
ActiveSheet.Rows("6:65356").Clear
Sheets("database").Activat
Dear Sonu,
Pls attach the solution file.
Pls let me know was it helpful or any problem.
Warm Regards
Bhushan Sabbani
+91 98208 26012
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tric
No file found.
On Mon, Apr 18, 2011 at 7:31 PM, Daniel wrote:
> Hi,
>
> Please, attach file ;-)
>
> Daniel
>
>
>
> *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> *De la part de* C.G.Kumar
> *Envoyé :* lundi 18 avril 2011 10:15
> *À :* excel-macros@googlegroups.com
Thnaks Ashish.
It is very useful but i am not getting desired output when i copy VBA code
to my actual workbook.Please suggest Where i have to make change.
Regards,
C.G.Kumar
On Mon, Apr 18, 2011 at 6:18 PM, ashish koul wrote:
> try this see if it helps
>
> On Mon, Apr 18, 2011 at 2:21 PM,
Hi,
Can any1 pls let me know how do i separate the text and nos in a
given sentence. PFA the sheet where i need to separate the nos and text.
Thanks.
--
--
Some important links for excel users:
1. Follow us on TWITT
Can someone help with the following: In one workbook named (Quote) I
would like to copy the contents of Columns A and B to another workbook
named (Anodize). Where the copied contents from (Quote) would be
placed on the next available blank row in Sheet1 Columns A and B. I
know how to place a Comman
16 matches
Mail list logo
