Excel security tip

Sectie: Overig
Auteur(s): Robert van der Hulst
Publicatiedatum: 29-4-2005
Keywords: Excel, MS Office
Type bijdrage: Artikel
Taal: Nederlands
Rating:
  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

The Question

I'm pumping data into an Excel file, but this Excel file has macros and security is set to medium, so a warning dialog appears asking if macros can be run.
Does anyone know how I can answer Yes to the dialog, or set the security level to Low before my session and restore it to medium after the session?

The Answer
You have to set the registry key:
HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Security
Create or Update the Value "Level" (type REG_DWORD )
1 = Low, 2 = Medium, 3 = High, 4 = Very High

Robert van der Hulst

Commentaar van anderen:
Amzika op 18-9-2009 om 14:44
Dank voor de tip, precies wat ik zocht!
ChristianLouboutin op 17-8-2010 om 2:45
Christian Louboutin Shoes, Christian Louboutin, Christian Louboutin Shoes, Wedding Shoes, Christian Louboutin Shoes, Christian Louboutin includes recently been produced in a selection with trends, designs, designs and also styles that will need achieved great decide of millions of most women several over the globally. Wedding Shoes, Christian Louboutin, Christian Louboutin Shoes, Wedding Shoes, Discount Christian Louboutin, Louboutin Sale A number of sizes are usually seriously outstanding and simply the rest are special variations among traditional general trends. Louboutin Shoes, Christian Louboutin Discount, Louboutin, Christian Louboutin Sale, Buy Christian Louboutin, Christian Louboutin Pumps, YSL Shoes sandals are known for their own particularly crafte heels, outstanding models and also high-priced and furthermore well highly regarded amongst girls cirlces. Christian Louboutin Sandals, Yves Saint Laurent Shoes, Christian Louboutin Boots, Manolo Blahnik Shoes, Yves Saint Laurent Boots, Miu Miu Shoes Sandals designs are glamorous and sexy, and they are worn by some of the world most beautiful women. Christian Dior Shoes, Christian Louboutin Flats, Christian, Louboutin Shoes, Christian Louboutin Sale, Discount Christian Louboutin Why is everyone infatuated with these red-soled shoes Read on to find out why, and you also find some of the best of Louboutin line. Herve Leger Bandage Dress, Herve Leger Dress, Herve Leger V Neck Dress, Herve Leger Bandage Dress, Herve Leger Dress Most people associate Louboutin shoes with sky-high, stiletto heels, the patent sandals with wedge heels prove that sexy and wearable can go hand-in-hand.
Geef feedback:
CAPTCHA image
Vul de bovenstaande code hieronder in
Verzend Commentaar