Why can't I record "flag for follow up" as a Macro?
 

Why can't I record "flag for follow up" as a macro? Is there some VBA code I
can use to summon it?

Why can't I record "flag for follow up" as a Macro?
 

Do you want to explain what you are talking about as I have no idea.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Richard Hocking" wrote in
message ...
Why can't I record "flag for follow up" as a macro? Is there some VBA code
I
can use to summon it?

Why can't I record "flag for follow up" as a Macro?
 

In the toolbar of Excel there is a red flag button - "flag for follow up"
which lets you set reminders to check the spreadsheet at a later date. I'd
like to expand on this - rather than just remind the user to look at the
whole spreadsheet, I want to get remind them about a specific cell, and,
ideally, specific data. I was hoping that by recording the "flag for follow
up" in a macro I could see the code it uses and expand on it. However, as
soon as I start recording a macro the "flag for follow up" button becomes
opaque and no longer click-able...

"Bob Phillips" wrote:

Do you want to explain what you are talking about as I have no idea.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Richard Hocking" wrote in
message ...
Why can't I record "flag for follow up" as a macro? Is there some VBA code
I
can use to summon it?

Why can't I record "flag for follow up" as a Macro?
 

Can you tell us what toolbar that is on? Sounds like you have some add-in
that other people don't use. I have looked hard and I have no idea what this
is either.

To see the name of the toolbar, grab it and drag it into the middle of your
screen, so that it detaches itself from the rest of the excel interface. You
can now see the name at the top. (you can do the same thing with the other
excel toolbars as well)

--
Allllen


"Richard Hocking" wrote:

In the toolbar of Excel there is a red flag button - "flag for follow up"
which lets you set reminders to check the spreadsheet at a later date. I'd
like to expand on this - rather than just remind the user to look at the
whole spreadsheet, I want to get remind them about a specific cell, and,
ideally, specific data. I was hoping that by recording the "flag for follow
up" in a macro I could see the code it uses and expand on it. However, as
soon as I start recording a macro the "flag for follow up" button becomes
opaque and no longer click-able...

"Bob Phillips" wrote:

Do you want to explain what you are talking about as I have no idea.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Richard Hocking" wrote in
message ...
Why can't I record "flag for follow up" as a macro? Is there some VBA code
I
can use to summon it?

Why can't I record "flag for follow up" as a Macro?
 

It's on my Standard tool bar?! In between the "save" and "print" buttons! I
do, unfortunately, have a Macintosh... is this something specific to that? I
don't have any add-ins installed either... it's after the "protection"
settings in the Tools menu too.

As it is, if I click it, it allows me to set a reminder to check the
spreadsheet at a later date, specified by me. Then, even if Excel isn't
running, a message appears on my screen at the specified time and day to
remind me.

I've not been taking anything illegal, I swear!!

Rich

"Allllen" wrote:

Can you tell us what toolbar that is on? Sounds like you have some add-in
that other people don't use. I have looked hard and I have no idea what this
is either.

To see the name of the toolbar, grab it and drag it into the middle of your
screen, so that it detaches itself from the rest of the excel interface. You
can now see the name at the top. (you can do the same thing with the other
excel toolbars as well)

--
Allllen


"Richard Hocking" wrote:

In the toolbar of Excel there is a red flag button - "flag for follow up"
which lets you set reminders to check the spreadsheet at a later date. I'd
like to expand on this - rather than just remind the user to look at the
whole spreadsheet, I want to get remind them about a specific cell, and,
ideally, specific data. I was hoping that by recording the "flag for follow
up" in a macro I could see the code it uses and expand on it. However, as
soon as I start recording a macro the "flag for follow up" button becomes
opaque and no longer click-able...

"Bob Phillips" wrote:

Do you want to explain what you are talking about as I have no idea.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Richard Hocking" wrote in
message ...
Why can't I record "flag for follow up" as a macro? Is there some VBA code
I
can use to summon it?

Why can't I record "flag for follow up" as a Macro?
 

Sorry Richard, i can't help. I waited to see if anyone else would reply. I
don't have any idea what this is
--
Allllen


"Richard Hocking" wrote:

It's on my Standard tool bar?! In between the "save" and "print" buttons! I
do, unfortunately, have a Macintosh... is this something specific to that? I
don't have any add-ins installed either... it's after the "protection"
settings in the Tools menu too.

As it is, if I click it, it allows me to set a reminder to check the
spreadsheet at a later date, specified by me. Then, even if Excel isn't
running, a message appears on my screen at the specified time and day to
remind me.

I've not been taking anything illegal, I swear!!

Rich

"Allllen" wrote:

Can you tell us what toolbar that is on? Sounds like you have some add-in
that other people don't use. I have looked hard and I have no idea what this
is either.

To see the name of the toolbar, grab it and drag it into the middle of your
screen, so that it detaches itself from the rest of the excel interface. You
can now see the name at the top. (you can do the same thing with the other
excel toolbars as well)

--
Allllen


"Richard Hocking" wrote:

In the toolbar of Excel there is a red flag button - "flag for follow up"
which lets you set reminders to check the spreadsheet at a later date. I'd
like to expand on this - rather than just remind the user to look at the
whole spreadsheet, I want to get remind them about a specific cell, and,
ideally, specific data. I was hoping that by recording the "flag for follow
up" in a macro I could see the code it uses and expand on it. However, as
soon as I start recording a macro the "flag for follow up" button becomes
opaque and no longer click-able...

"Bob Phillips" wrote:

Do you want to explain what you are talking about as I have no idea.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Richard Hocking" wrote in
message ...
Why can't I record "flag for follow up" as a macro? Is there some VBA code
I
can use to summon it?

Why can't I record "flag for follow up" as a Macro?
 

Hi Richard

Right click on a blank area of your toolbars.
From the dropdown select Customise
Now, if you right click on your icon, you should be able to see if a
macro has been assigned to that button for it is not like anything I
have ever come across in Excel.

--
Regards

Roger Govier


"Richard Hocking" wrote in
message ...
It's on my Standard tool bar?! In between the "save" and "print"
buttons! I
do, unfortunately, have a Macintosh... is this something specific to
that? I
don't have any add-ins installed either... it's after the
"protection"
settings in the Tools menu too.

As it is, if I click it, it allows me to set a reminder to check the
spreadsheet at a later date, specified by me. Then, even if Excel
isn't
running, a message appears on my screen at the specified time and day
to
remind me.

I've not been taking anything illegal, I swear!!

Rich

"Allllen" wrote:

Can you tell us what toolbar that is on? Sounds like you have some
add-in
that other people don't use. I have looked hard and I have no idea
what this
is either.

To see the name of the toolbar, grab it and drag it into the middle
of your
screen, so that it detaches itself from the rest of the excel
interface. You
can now see the name at the top. (you can do the same thing with the
other
excel toolbars as well)

--
Allllen


"Richard Hocking" wrote:

In the toolbar of Excel there is a red flag button - "flag for
follow up"
which lets you set reminders to check the spreadsheet at a later
date. I'd
like to expand on this - rather than just remind the user to look
at the
whole spreadsheet, I want to get remind them about a specific cell,
and,
ideally, specific data. I was hoping that by recording the "flag
for follow
up" in a macro I could see the code it uses and expand on it.
However, as
soon as I start recording a macro the "flag for follow up" button
becomes
opaque and no longer click-able...

"Bob Phillips" wrote:

Do you want to explain what you are talking about as I have no
idea.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Richard Hocking"
wrote in
message
...
Why can't I record "flag for follow up" as a macro? Is there
some VBA code
I
can use to summon it?

Why can't I record "flag for follow up" as a Macro?
 

Ah, looking in the "help" menu, it says the following about what's new in
Excel X...


Flag for follow-up (new in 2001) If you have Microsoft Entourage
installed, you can flag workbooks for follow-up at a later date and time, and
Entourage will alert you.


So I guess it's perhaps specific to the Mac, plus needs other software
installed! never mind. Would have been useful to be able to customise a
reminder of cells that had been recently altered.

"Roger Govier" wrote:

Hi Richard

Right click on a blank area of your toolbars.
From the dropdown select Customise
Now, if you right click on your icon, you should be able to see if a
macro has been assigned to that button for it is not like anything I
have ever come across in Excel.

--
Regards

Roger Govier


"Richard Hocking" wrote in
message ...
It's on my Standard tool bar?! In between the "save" and "print"
buttons! I
do, unfortunately, have a Macintosh... is this something specific to
that? I
don't have any add-ins installed either... it's after the
"protection"
settings in the Tools menu too.

As it is, if I click it, it allows me to set a reminder to check the
spreadsheet at a later date, specified by me. Then, even if Excel
isn't
running, a message appears on my screen at the specified time and day
to
remind me.

I've not been taking anything illegal, I swear!!

Rich

"Allllen" wrote:

Can you tell us what toolbar that is on? Sounds like you have some
add-in
that other people don't use. I have looked hard and I have no idea
what this
is either.

To see the name of the toolbar, grab it and drag it into the middle
of your
screen, so that it detaches itself from the rest of the excel
interface. You
can now see the name at the top. (you can do the same thing with the
other
excel toolbars as well)

--
Allllen


"Richard Hocking" wrote:

In the toolbar of Excel there is a red flag button - "flag for
follow up"
which lets you set reminders to check the spreadsheet at a later
date. I'd
like to expand on this - rather than just remind the user to look
at the
whole spreadsheet, I want to get remind them about a specific cell,
and,
ideally, specific data. I was hoping that by recording the "flag
for follow
up" in a macro I could see the code it uses and expand on it.
However, as
soon as I start recording a macro the "flag for follow up" button
becomes
opaque and no longer click-able...

"Bob Phillips" wrote:

Do you want to explain what you are talking about as I have no
idea.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Richard Hocking"
wrote in
message
...
Why can't I record "flag for follow up" as a macro? Is there
some VBA code
I
can use to summon it?