Reletive Referencing - Marco issues

[craiglittleperth]

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

 

[Bernie Deitrick]

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

 

[craiglittleperth]

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












- 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

 

[Bernie Deitrick]

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