Morning All,

I am having a little bit of a problem.

When I normally build out my macros i cheat by recording bits of the
action and stringing them together....not best practice I know..but
does the little tasks i need.

However... moving to a new job and a new computer, it would seem i
can't TURN OFF Relative Referencing in my macro recorder! Even though
i am pushing the toggle button (that we all know is very vauge anyway)
to both on and off. Relative referencing is always recorded in the VBA
coding....

Can anyone help me please.. .. before i have to manually sort and
filter 137 work sheets!! ouch!!!!

Thank you

Craig

Craig,

Try resetting the commandbar:

Application.CommandBars("Stop Recording").Reset

Otherwise, post your code and your questions here, and you'll be fine. Neither mode makes code that
is ideal, and either mode makes code that you can fix to do what you want.

HTH,
Bernie
MS Excel MVP


wrote in message
oups.com...
Morning All,

I am having a little bit of a problem.

When I normally build out my macros i cheat by recording bits of the
action and stringing them together....not best practice I know..but
does the little tasks i need.

However... moving to a new job and a new computer, it would seem i
can't TURN OFF Relative Referencing in my macro recorder! Even though
i am pushing the toggle button (that we all know is very vauge anyway)
to both on and off. Relative referencing is always recorded in the VBA
coding....

Can anyone help me please.. .. before i have to manually sort and
filter 137 work sheets!! ouch!!!!

Thank you

Craig

On 12 Oct, 14:42, "Bernie Deitrick" <deitbe @ consumer dot org wrote:
Craig,

Try resetting the commandbar:

Application.CommandBars("Stop Recording").Reset

Otherwise, post your code and your questions here, and you'll be fine. Neither mode makes code that
is ideal, and either mode makes code that you can fix to do what you want.

HTH,
Bernie
MS Excel MVP

wrote in message

oups.com...



Morning All,

I am having a little bit of a problem.

When I normally build out my macros i cheat by recording bits of the
action and stringing them together....not best practice I know..but
does the little tasks i need.

However... moving to a new job and a new computer, it would seem i
can't TURN OFF Relative Referencing in my macro recorder! Even though
i am pushing the toggle button (that we all know is very vauge anyway)
to both on and off. Relative referencing is always recorded in the VBA
coding....

Can anyone help me please.. .. before i have to manually sort and
filter 137 work sheets!! ouch!!!!

Thank you

Craig- Hide quoted text -

- Show quoted text -

hi Bernie,

Thank you for this. It doesn't work unfortunatly. I can post the
coding. But it is none too pretty, and until I can turn this relative
referencing off!!

have you any other thoughts?

Thanks

Craig

Craig,

Follow the various techniques shown here, on Chip Pearson's excellent web site:

http://www.cpearson.com/excel/StartupErrors.htm

That may reset whatever it is that is preventing the button from actually working.

HTH,
Bernie
MS Excel MVP


wrote in message
ups.com...
On 12 Oct, 14:42, "Bernie Deitrick" <deitbe @ consumer dot org wrote:
Craig,

Try resetting the commandbar:

Application.CommandBars("Stop Recording").Reset

Otherwise, post your code and your questions here, and you'll be fine. Neither mode makes code
that
is ideal, and either mode makes code that you can fix to do what you want.

HTH,
Bernie
MS Excel MVP

wrote in message

oups.com...



Morning All,

I am having a little bit of a problem.

When I normally build out my macros i cheat by recording bits of the
action and stringing them together....not best practice I know..but
does the little tasks i need.

However... moving to a new job and a new computer, it would seem i
can't TURN OFF Relative Referencing in my macro recorder! Even though
i am pushing the toggle button (that we all know is very vauge anyway)
to both on and off. Relative referencing is always recorded in the VBA
coding....

Can anyone help me please.. .. before i have to manually sort and
filter 137 work sheets!! ouch!!!!

Thank you

Craig- Hide quoted text -

- Show quoted text -

hi Bernie,

Thank you for this. It doesn't work unfortunatly. I can post the
coding. But it is none too pretty, and until I can turn this relative
referencing off!!

have you any other thoughts?

Thanks

Craig