I recently posted this topic: http://www.mrexcel.com/board2/viewtopic.php?t=181179&highlight=enlarge+pics
It worked fine till I was testing out my whole spreadsheet and found out that since I have started using these macros, my buttons at the top of my spreadsheets will no longer work. If I open the workbook and enable macros, then I experience the problem, if I open the workbook and dis-able the macros, then the buttons work like they should. The two buttons I refer to, are simply just hyperlinked to another spreadsheet within the same workbook. I am not too experienced with excel, but I think it has something to do with the macros referring to "object". I noticed when I right click on the buttons, it refers to them as objects also.
The coding for both macros is listed in the previous post for you guys to look at.
I hate to lose the macros, because they enlarge the pics just like I needed them to and I would really love to be able to use the hyperlinked buttons on the same spreadsheets as well.
Thank you guys for all your help!!!!
It worked fine till I was testing out my whole spreadsheet and found out that since I have started using these macros, my buttons at the top of my spreadsheets will no longer work. If I open the workbook and enable macros, then I experience the problem, if I open the workbook and dis-able the macros, then the buttons work like they should. The two buttons I refer to, are simply just hyperlinked to another spreadsheet within the same workbook. I am not too experienced with excel, but I think it has something to do with the macros referring to "object". I noticed when I right click on the buttons, it refers to them as objects also.
The coding for both macros is listed in the previous post for you guys to look at.
I hate to lose the macros, because they enlarge the pics just like I needed them to and I would really love to be able to use the hyperlinked buttons on the same spreadsheets as well.
Thank you guys for all your help!!!!
