R
Richard Hocking
Why can't I record "flag for follow up" as a macro? Is there some VBA code I
can use to summon it?
can use to summon it?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Phillips
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)
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
R
Richard Hocking
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...
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...
A
Allllen
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)
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)
R
Richard Hocking
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
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
A
Allllen
Sorry Richard, i can't help. I waited to see if anyone else would reply. I
don't have any idea what this is
don't have any idea what this is
R
Roger Govier
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.
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.
R
Richard Hocking
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.
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.