hi
Sam Mathai Chacko,
Don Guillett.
thanks for ur responce
Actually this Excel Project Will work like this:
here Ohlc Sheet Having data it is automatically coming from yahoo site
if we need to select symbol, next cell for company, and enter starting
date and ending date then click on get data
Hi,
I want a macro that will restrict in a cell to enter data
Thanks Regards
Rajesh Mahapatra
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need
Rajesh,
Why don't you just protect the sheet, after leaving all free-to-edit cells'
property as unlocked, and those cells which you want to restrict as locked.
Regards,
Sam Mathai Chacko
On Sat, Nov 19, 2011 at 4:35 PM, rajafs...@gmail.com rajafs...@gmail.comwrote:
Hi,
I want a macro that
Attach your file with a REPLY to this email
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: renuka chari
Sent: Saturday, November 19, 2011 3:31 AM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Macro Chart Problem For Stack Exchange Program
hi
As Sam says, how does your new info get in. Do you manually insert, where???
As it now sits you can define a name
months
refers to
=offset($a$5,3,0,13,1)
and then
inside
=offset(months,0,2)
then use
=nameofile.xlsx!months
and
=nameofile.xlsx!inside
Don Guillett
SalesAid Software
Doesn’t seem right but then try my suggestion with this change to always start
at row 8
months
=OFFSET(INDIRECT($A$ 8),0,0,13,1)
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Steve Weaver
Sent: Saturday, November 19, 2011 9:14 AM
To: excel-macros@googlegroups.com
Cc: Sam Mathai
Dear Rajesh,
SAM's Suggestion is good,
You can try also.
Private Sub Worksheet_Change(ByVal Target As Range)
Dim cell As Range
Set cell = Target
ActiveSheet.Unprotect
cell.Locked = True
ActiveSheet.Protect
End Sub
On Sat, Nov 19, 2011 at 4:35 PM, rajafs...@gmail.com rajafs...@gmail.comwrote:
Hi,
You can record macro for both action with shortcut keys. I use CTRL+E
CTRL+R in below shown code.
*
Sub Protect()
'
' Macro1 Macro
'
' Keyboard Shortcut: Ctrl+e
'
ActiveSheet.Protect DrawingObjects:=True, Contents:=True,
Scenarios:=True
End Sub
Sub Unprotect()
'
' Macro2 Macro
'
'
Dear All,
I am thankful to all of friends who responded me well, but it is my
fault that i could not mention my problem clearly. Therefore I once
again try to mention please help me in this regard as earlier.
Problem:
Suppose I have one two columns A1 B1. In column A1 I entered
Different
How does that relate to the sample provided? If you want for a DIFFERENT
sample, please provide. If not, tell us which columns you want to print and
why is the word do in the otherwise blank cells???
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From:
Try the code below after running a print preview on the spreadsheet:
Sub fmtprntrng()
Dim rngCell As Range
Dim hpb As HPageBreak
Dim wks As Worksheet
Dim rg1 As String, rg2 As String, rg3 As String
'Application.ScreenUpdating = 0
Set wks = Worksheets(Sample Data)
For
Hi,
How your current file operates is more or less understandable from
your previous file. Somehow what changes you need are still not clear.
As Mr Don Guillett says could you attach a sample file with both
current method and results that you need after change as sample?
Regards,
Anand Kumar
On
12 matches
Mail list logo