What I think you want to do is going to need some quite complex programming.
First, let me check that I have the right idea about what you want.
When any workbook opens on your computer, you want to have the the entire
row and the entire column of the active cell highlighted with a yellow
coloured background.
When you change the active cell, say move right or down, or click elsewhere
in the sheet, you then want to (a)remove the original highlighting and
(b)make the new row and column highlighted.
If a range comprising more than one cell is selected, you want to apply
this to the active cell. (i.e. the top left hand cell in the range) So
there will always only be one column and one row highlighted.
There are some issues to deal with:
1) this process will require code to be inserted in the ThisWorkbook
module of each workbook.
2) If there is already code in the workbook, relating to the relevant
events, the new code will need to be combined with this code.
3) Do you want the highlighting to be retained in the workbook after it is
closed?
4) Would it be a concern if the highlighting remained in the workbook and
could not be automatically removed if the program of computer crashed?
5) what do you want to do if there is existing colouring in cells of the
workbook? Options are (a) overwrite them with the highlighting and then
remove the highlighting leaving them without a color fill; (b) do not
highlight coloured cells; (c) highlight them but restore the original
colour when removing the highlighting (very complex to code); (d) only
highlight non-coloured cells (even more complex to code).
6) will this definitely only be used on your computer. Is there any
restriction preventing you using code which accesses the code modules?
Allowing this access is a security risk. Are you prepare to take this
risk?
7) Do you need this to apply to every workbook you open, including new
workbooks you create, and workbooks prepared by other people? If so is
there any likelihood that you will receive workbooks from others with
password protected code? If so what do you want to do about this as you
would be unable to write your code into their ThisWorkbook modules?
8) do you want to leave the code in each workbook so it runs if you give
the workbook to anybody else? or do you want to delete it before the
workbook is closed?
Is this something you just think would be a fun thing to have or would you
consider paying a developer to implement it? I suspect there is several
hours work in implementing it properly and I am not prepared to spend that
amount of time myself, doing it unless you are prepared to pay $1,000 US.
Other members of the group may have plenty of time to spare and be willing
to donate that time.
Regards
David Grugeon.
Regards
David Grugeon
On 11 March 2013 16:33, karthikeyan sankaran karthikeyansankar...@gmail.com
wrote:
Hi,
Thanks for your reply.
I need Active cell RowColumn. Whenever open the workbook it will show
automatically.
Thanks
karthik
On 11 March 2013 11:30, अनिल नारायण गवली gawlianil8...@gmail.com wrote:
Dear Karthikeyansankaran,
Goto sheet view code their select worksheet from dropwdown.
Write the code .
ActiveCell.Interior.ColorIndex = 36
Warm Regards,
Gawli Anil
On Sun, Mar 10, 2013 at 5:53 PM, karthikeyan sankaran
karthikeyansankar...@gmail.com wrote:
Hi,
How to highlight ActiveCell Row and Column for all workbook. which means
excel open it will active automatically.
Thanks
karthik
--
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, Formula Problem, Code Problem, and Need Advice
will not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google
Groups MS EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send
an email to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
--
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
--
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
