I have a spreadsheet that I want to add a button to Insert Logo that once inserted will size down to a certain width and height. The picture file may be located at different locations on the computer so I want Excel to prompt me for the location of the file name. I know the invoice.xlt template file has this macro (under Customize) but I cannot simply link my button to this macro. I receive the error Run-time Erro 9-Subscript out of range. I cannot edit or view the macro contents in the invoice.xlt file because it is password protected. Has anyone been able to access the VBA code for the invoice.xlt file? I tried password recovery programs but not luck. Or can anyone help me with a macro that will do the trick?
Thank you!
Thank you!