Sweet & simply - how do I enable a macro? - MANUALLY

B

bobg.hahc

running excel 2k;

All I want to know, is how do I enable a macro.
I don't care if the sheet opens & ASK's if it's OK to enable macros -
I want to know how to do MANUALLY - whatever the "yes" answer to that
question is doing?

What pulldown / button do I access to enable macros?

And PLEASE don't tell me I have to lower my security! ;-)

So - in sum - I want to manually enable macros without taking my
security off high.
I've searched help (yes, I actually try this first, I don't know why -
I almost never get an answer I want); searched the groups, found
nothing that addresses this seemingly simple question.

TIA - Bob
 
J

Jim Thomlinson

Look at digitally signing your project. Other than that there is not much you
can do except (I know you don't want to hear this) lower your security to
medium. That is the whole point to the medium security level... To give you
the option to enable macro's...
 
B

bobg.hahc

LoL

Jim;

TX much; appreciate your reply!

yep; nothing I like less than telling a user to lower security - way
too scary!
But you did answer my question, and the answer is, can't be done.
(not the way I want it done anyway:)

it seems that dig sig would then be the only solution. this is fine
for me, but not for the [above]-average user that writes their own
macros...

I've never digitally signed anything, so I'll look into that... assume
I can create my own certificate - this is all internal use type
stuff....

TX again!
Bob
 
G

Gord Dibben

You can create a dig sig for your computer using the MS Office SelfCert Tool.

The key cannot be exported to another computer.

See more on this in Excel Help>digital certificate


Gord Dibben MS Excel MVP

LoL

Jim;

TX much; appreciate your reply!

yep; nothing I like less than telling a user to lower security - way
too scary!
But you did answer my question, and the answer is, can't be done.
(not the way I want it done anyway:)

it seems that dig sig would then be the only solution. this is fine
for me, but not for the [above]-average user that writes their own
macros...

I've never digitally signed anything, so I'll look into that... assume
I can create my own certificate - this is all internal use type
stuff....

TX again!
Bob

Look at digitally signing your project. Other than that there is not much you
can do except (I know you don't want to hear this) lower your security to
medium. That is the whole point to the medium security level... To give you
the option to enable macro's...
 
B

bobg.hahc

Gord-

Terrific! biggest problem in finding stuff w/ ms, is knowing where to
search, and what to search for ;-)

Didn't know you could do this.... great to know!

TX again!

You can create a dig sig for your computer using the MS Office SelfCert Tool.

The key cannot be exported to another computer.

See more on this in Excel Help>digital certificate

Gord Dibben MS Excel MVP

LoL

TX much; appreciate your reply!
yep; nothing I like less than telling a user to lower security - way
too scary!
But you did answer my question, and the answer is, can't be done.
(not the way I want it done anyway:)
it seems that dig sig would then be the only solution. this is fine
for me, but not for the [above]-average user that writes their own
macros...
I've never digitally signed anything, so I'll look into that... assume
I can create my own certificate - this is all internal use type
stuff....
TX again!
Bob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top