Forum Discussion
Hyperlink to a chart (not to a cell coordinate)
Good morning. Our firm concentrates on providing training for people with disabilities, and I have been developing Excel tools that allow visually impaired individuals to access spreadsheets using t...
Hi Jan,
Thank you for the quick reply and solution. I must admit however that you have me at a disadvantage. I don't know what you mean by placing a code in the ThisWorkbook module. Would you be able to provide me with further guidance? Thanks.
Best,
Ed
Right-click any sheet's tab and select "View Code". Now the VBA editor of Excel opens. On the left you should see a small window which is called "Project Explorer". In that window yu should see a small folder-like structure with the name of your workbook in there somewhere. Under that project you should have a folder called "Microsoft Excel Objects" andone of the subitems there is "ThisWorkbook". Double-click that item. Then paste my code in the window that just opened.
Mind you, after doing so, save-as your file as Excel workbook with macro's.
Mind you, after doing so, save-as your file as Excel workbook with macro's.
Jan,
That worked! Thank you so much.
Best,
Ed