I have a macro that uses AcceptLabelsInFormulas for Excel/Office 2003, but
does not work in Excel 2007. This macro is used by many in our office. Is
there a work around or should we just remove the Office 2007 for Business and
go back to the original Office?

Can you use Defined Names instead?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"QMC Developer" <QMC wrote in message
...
I have a macro that uses AcceptLabelsInFormulas for Excel/Office 2003, but
does not work in Excel 2007. This macro is used by many in our office.
Is
there a work around or should we just remove the Office 2007 for Business
and
go back to the original Office?

Thanks Niek,

I will give the Names method one more go. Had issues with much more
programming required (over 100 macros with over 100 self generating
Labels/macro). The other issue is that names/comments need to be deleted,
multiple macros may use the same Label, and XL used versions are from 97 (for
some old client formatting requirements and established client use
"with-confidence") to 2007+. The "boss-man" is upset since we may now need
to get recertified all because a very simple, robust and easy to use
AcceptLabelsInFormulas method has been eliminated by microsoft, to bad...

Again Much Thanks - ,

"Niek Otten" wrote:

Can you use Defined Names instead?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"QMC Developer" <QMC wrote in message
...
I have a macro that uses AcceptLabelsInFormulas for Excel/Office 2003, but
does not work in Excel 2007. This macro is used by many in our office.
Is
there a work around or should we just remove the Office 2007 for Business
and
go back to the original Office?