I have a single tab worksheet that has a button on it (with the code embedded in that tab - not personal.xls) that I copy into other workbooks to use. But the problem was that the button kept looking for the macro in the original file and not the new file. Basically it's like a relative reference vs absolute macro reference. I would have to keep editing the button to point it to the correct tab macro. However, I tried making the tab again and insert it into a new sheet and the button is performing with relative reference as apposed to absolute reference. My question is what did I do to fix it???

Thanks in advance,

Grez

Please Login or Register  to view this content.