Cannot run the macro 'CIQKEYS_PreviousSheet'...

T_mac_wfa · External Since: Sep 03, 2009 Posts: 1

MSFT Office xls 2007...
my 'ctrl+page up' and 'ctrl+page down' function no longer moves from tab to
tab rather a message pops up telling me..
"Cannot run the macro 'CIQKEYS_PreviousSheet'. The Macro may not be
available in this workbook or all macros may be disabled."
or same message with 'CIQKEYS_NextSheet'

My settings appear to be fine...other macros performly properly...this
function worked 48 hours ago and i have not done anything new

anyone have an idea -- this is killing me!

jfishburn · External Since: Sep 05, 2009 Posts: 3

I have been having the same problem. Do you have any add-ins running?

"T_mac_wfa" wrote:

> MSFT Office xls 2007...
> my 'ctrl+page up' and 'ctrl+page down' function no longer moves from tab to
> tab rather a message pops up telling me..
> "Cannot run the macro 'CIQKEYS_PreviousSheet'. The Macro may not be
> available in this workbook or all macros may be disabled."
> or same message with 'CIQKEYS_NextSheet'
>
> My settings appear to be fine...other macros performly properly...this
> function worked 48 hours ago and i have not done anything new
>
> anyone have an idea -- this is killing me!
>

jfishburn · External Since: Sep 05, 2009 Posts: 3

I just disabled a plug-in from Capital IQ and the problem goes away. I don't
know if you are running that plug-in, but it could be your problem as well.

"T_mac_wfa" wrote:

> MSFT Office xls 2007...
> my 'ctrl+page up' and 'ctrl+page down' function no longer moves from tab to
> tab rather a message pops up telling me..
> "Cannot run the macro 'CIQKEYS_PreviousSheet'. The Macro may not be
> available in this workbook or all macros may be disabled."
> or same message with 'CIQKEYS_NextSheet'
>
> My settings appear to be fine...other macros performly properly...this
> function worked 48 hours ago and i have not done anything new
>
> anyone have an idea -- this is killing me!
>

T_mac_wfa · External Since: Sep 08, 2009 Posts: 2

i am using CapIQ -- I will try your suggestion...
--
T_mac_wfa

"jfishburn" wrote:

> I just disabled a plug-in from Capital IQ and the problem goes away. I don't
> know if you are running that plug-in, but it could be your problem as well.
>
> "T_mac_wfa" wrote:
>
> > MSFT Office xls 2007...
> > my 'ctrl+page up' and 'ctrl+page down' function no longer moves from tab to
> > tab rather a message pops up telling me..
> > "Cannot run the macro 'CIQKEYS_PreviousSheet'. The Macro may not be
> > available in this workbook or all macros may be disabled."
> > or same message with 'CIQKEYS_NextSheet'
> >
> > My settings appear to be fine...other macros performly properly...this
> > function worked 48 hours ago and i have not done anything new
> >
> > anyone have an idea -- this is killing me!
> >

T_mac_wfa · External Since: Sep 08, 2009 Posts: 2

It worked!
Thank you very much.
I will give the guys at CapIQ a call and have them take a look...
--
T_mac_wfa

"jfishburn" wrote:

> I just disabled a plug-in from Capital IQ and the problem goes away. I don't
> know if you are running that plug-in, but it could be your problem as well.
>
> "T_mac_wfa" wrote:
>
> > MSFT Office xls 2007...
> > my 'ctrl+page up' and 'ctrl+page down' function no longer moves from tab to
> > tab rather a message pops up telling me..
> > "Cannot run the macro 'CIQKEYS_PreviousSheet'. The Macro may not be
> > available in this workbook or all macros may be disabled."
> > or same message with 'CIQKEYS_NextSheet'
> >
> > My settings appear to be fine...other macros performly properly...this
> > function worked 48 hours ago and i have not done anything new
> >
> > anyone have an idea -- this is killing me!
> >

jfishburn · External Since: Sep 05, 2009 Posts: 3

Right on. Glad to help.

"T_mac_wfa" wrote:

> It worked!
> Thank you very much.
> I will give the guys at CapIQ a call and have them take a look...
> --
> T_mac_wfa
>
>
> "jfishburn" wrote:
>
> > I just disabled a plug-in from Capital IQ and the problem goes away. I don't
> > know if you are running that plug-in, but it could be your problem as well.
> >
> > "T_mac_wfa" wrote:
> >
> > > MSFT Office xls 2007...
> > > my 'ctrl+page up' and 'ctrl+page down' function no longer moves from tab to
> > > tab rather a message pops up telling me..
> > > "Cannot run the macro 'CIQKEYS_PreviousSheet'. The Macro may not be
> > > available in this workbook or all macros may be disabled."
> > > or same message with 'CIQKEYS_NextSheet'
> > >
> > > My settings appear to be fine...other macros performly properly...this
> > > function worked 48 hours ago and i have not done anything new
> > >
> > > anyone have an idea -- this is killing me!
> > >