Hyperlinks & Delete Drawing Objects

**Zenarte** · 03-24-2010, 09:06 PM

Hello, I'm an Office 2003 user, and I developed this code where I have a couple of functions that won't actually work on the 2007 version. I'd please like to know if anyone here would be able to help me out.

First problem:

"ActiveSheet.DrawingObjects.Delete": Is there any similar command that will work on this newer version?

Second problem:

Please Login or Register  to view this content.

Well, that didn't worked either. I can click at D12 as much as I want to, and that will never link me to where I'd like to go... Any other way to link a certain cell to a desired sheet?

Thanks in advance!

**royUK** · 03-25-2010, 02:33 AM

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Also, read the Rule #1 Thread Titles & unnecessary wording - VBA(Office 2007). Your version of excel should be added to your profile

**Zenarte** · 03-25-2010, 08:29 AM

Ok roy, I'm sorry about that, I just edited the thread as you requested. But you know, even if I'd write on my profile that I use the 2003 version, I'd still need to mention about the 2007 version, otherwise my post would be pointless (except maybe for the title, where I erased the "VBA (Office 2007)" part, as you also required).

Thanks for the hints, I hope that someone can help me ~