I have an excel spreadsheet for attendance at a school where I teach, and there are dozens of this weird hidden/invisible hyperlink inside an "autoshape" on each page. They're all mailto links, and almost all of them are for emails where the people have retired or are no longer at my school. The teacher who generated this spreadsheet also has retired, and so isn't available to be asked about it.
I am reasonably sure that there is a way to remove all of these "autoshapes" with mailto links without randomly moving around the spreadsheet, finding one accidentally, right-clicking, unlocking, and then deleting it. On one page I found 19 of these things.
Please help! I am at my wit's end, and I know there should be an easy way to remove and disable all of them at the same time. They cover up cells we need to use for attendance, and it makes life difficult!
Thanks!
Bookmarks