Alternative for INDIRECT

**DonkeyOte** · 01-26-2009, 02:09 PM

I believe there is an issue with 2007 but for other versions yes I believe so ... all very clever :-) ... but still need to install it as 3rd party initially which as shg says - IT may not be overly keen upon... but what they don't know...

**shg** · 01-26-2009, 02:32 PM

I'm sure you have to do Trust access to VBA project for it to work -- and code that modifies code makes some virus scanners very nervous.

**Hein** · 01-27-2009, 05:31 AM

Sorry for not responding sooner, but I thought that this thread was over/closed.

One of the reasons why I'm not happy to use 3rd party add-ins is that our IT dept may not approve.
The other is that the file will be embedded in SAP and I'm not sure what's going to happen if I change/add it.

I have found a way to keep the file(-s) usable.
I will dig into your sugegstions as a learning experience and use it in other places (eg private)

Thanks for all your suggestions and contributions

Hein