Prev: Split cells across multiple columns
Next: unable to open .xlb file in Windows 7
From: Robcole84 on 17 Feb 2010 17:06
Hello, I am trying to follow the directions from...

http://www.contextures.com/xlDataVal11.html

using office 2007 but nothing I'm doing is working! I enabled the developer
tab and followed everything down to a tee but no luck. I finally downloaded
the sample and even it doesn't work the way its supposed to! Looked at the
code and it says option explicit at the very top. I do not know VB but im
guessing the code isn't working right. Does anyone know how to do this or a
site listing instructions for office 2007?

Tried doing searches for this but it seems like everywhere i look link back
to this same website!

Thanks in advance!
From: Gord Dibben on 17 Feb 2010 17:33
The code is working fine for me in 2007.

First you must save the sample workbook as a macro-enabled file in 2007
which allows code to run if your security settings allow.

Check those settings in Developer Tab>Macro Security.

Allow to run with notofication or add the folder where the file is stored to
your "Trusted Locations".


Gord Dibben MS Excel MVP


On Wed, 17 Feb 2010 14:06:02 -0800, Robcole84
<Robcole84(a)discussions.microsoft.com> wrote:

>Hello, I am trying to follow the directions from...
>
>http://www.contextures.com/xlDataVal11.html
>
>using office 2007 but nothing I'm doing is working! I enabled the developer
>tab and followed everything down to a tee but no luck. I finally downloaded
>the sample and even it doesn't work the way its supposed to! Looked at the
>code and it says option explicit at the very top. I do not know VB but im
>guessing the code isn't working right. Does anyone know how to do this or a
>site listing instructions for office 2007?
>
>Tried doing searches for this but it seems like everywhere i look link back
>to this same website!
>
>Thanks in advance!

 | 
Pages: 1
Prev: Split cells across multiple columns
Next: unable to open .xlb file in Windows 7