Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 7th 08, 06:58 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2008
Posts: 2
Default Function to Check if Cell is Highlighted for Change in Shared Work

Good afternoon, everyone. I've been banging my head against the wall trying
to figure this out for a few days.

I am looking to create a shared workbook and utilize the track changes
feature. In this workbook I want to write a function that refers to another
cell and tells me whether or not that cell is highlighted as being changed
(i.e. has the blue triangle in the top left corner). It is extremely
important that it refers to whether or not Excel is highlighting it because I
want the function result to change if the highlight change date range is
changed.

I figured out how to have the function check a cell for comments, but since
these only look like comment it doesn't work. I'm hoping the VBA language is
similar, but for the life of me I can't find how to reference the highlight
for change.

Any help would be greatly appreciated!

  #2   Report Post  
Old October 7th 08, 08:57 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2006
Posts: 471
Default Function to Check if Cell is Highlighted for Change in Shared Work

What if you put a function in the ThisWorkbook area on selection change:

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target
As Range)

End Sub

Then you could monitor the changes yourself and create whatever log you want.
Note, you'll need to record the "starting" position of the cursor when you
open the workbook so you can then track a change. This is basically what I
use all the time. HTH.

  #3   Report Post  
Old October 7th 08, 09:45 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2008
Posts: 2
Default Function to Check if Cell is Highlighted for Change in Shared

I'm not exactly sure how I'd make that work. The reason I am trying to base
this on the cell being highlighted/having the blue triangle is this:

My employees will be making changes to the spreadsheet throughout the month,
but let's say I only want to see the changes that were made in the past 5
days. I could then just do Highlight Changes Since [Date]. I only really care
about changes made in certain columns, so I'm looking to use this function to
check that particular cell in that row is highlighted for change in that
specific time frame.

For comments the reference is something like (Cell).Comment.Text....is there
no way to make a similar reference for this type of situation?


"Mike H." wrote:

What if you put a function in the ThisWorkbook area on selection change:

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target
As Range)

End Sub

Then you could monitor the changes yourself and create whatever log you want.
Note, you'll need to record the "starting" position of the cursor when you
open the workbook so you can then track a change. This is basically what I
use all the time. HTH.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
change cell link for many check boxes at once AndyC812 Excel Discussion (Misc queries) 7 November 10th 08 02:47 AM
How do I change the size of a check box to fit cell? MTE Excel Discussion (Misc queries) 0 April 27th 06 04:04 PM
Can I use a function to detect whether a cell is highlighted? Martin Williams Excel Worksheet Functions 2 January 23rd 06 12:51 PM
How do you change the default colour a cell is highlighted in? CMorris Excel Discussion (Misc queries) 0 December 14th 05 11:46 AM
Macro to make a cell work like a check Logan[_2_] Excel Programming 2 February 3rd 04 05:11 AM


All times are GMT +1. The time now is 01:38 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017