 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / February 2008Sweet & simply - how do I enable a macro? - MANUALLY
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 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...  SignatureHTH... Jim Thomlinson > running excel 2k; > [quoted text clipped - 14 lines] > > TIA - Bob 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 On Feb 6, 12:10 pm, Jim Thomlinson <James_Thomlin...@owfg-Re-Move- This-.com> wrote: > 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 [quoted text clipped - 24 lines] > > > TIA - Bob 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 > [quoted text clipped - 48 lines] >> >> > TIA - Bob 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. > [quoted text clipped - 56 lines] > > >> > TIA - Bob |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.