Custom UI editor for excel... They missed something!!!

Hello,

Ok, I followed the video at:

https://www.youtube.com/watch?v=ZTt2FFyj2Fo

The only problem is when I click on a custom button on the ribbon, the only way it runs the macro (My sub called xxx) is if its in a module!!!! But my sub xxx() needs to be ran while residing in sheet1 of the project !!!

And that's because, the Worksheet_Change() event gets automatically and purposely called by sub xxx()!

So I tried making a dummy sub in a module which then calls my Sub xxx() and the dummy sub can't call Sub xxx() because it claims it doesn't see its definition .....

What now....

Because of these two conditions (which I have been testing all day ) I think Excel missed something here!

IF:

- It is impossible to call a sub residing in sheet1 code from a module ????

and

- It is impossible for ribbon button to call a sub residing in sheet1 code ???

Then what is one suppose to do when he has code in sheet1 and needs it to be executed from a custom ribbon button

Anyone have a work around to this!

Thanks all
RN

Hi,

Try to assign the macro to 'Sheet1.xxx' in the ribbon Button. Sheet1 is the Excel Code name for the sheet, not the name that the User sees (which can also be Sheet1).

If you still need help, please upload a sample workbook that contains the macro and the ribbon button.

Lewis

Haaaaaa Lewis!!!!

You are my savior !!!!!

Your suggestion worked....

Thank you very very much for your help!

Rn