Enable Macros - Trust my file on my PC

How do I set my file so that Excel does not ask me to enable macros every time I start up this workbook I am making? I cannot change the security settings on my PC since this is a work computer and others use it.

What I would like to do is set something in my file or some setting in my securty so that this one file I am working on is trusted and I am not constantly asked if I want to enable them or not. Thanks.

The one file would have to be certified and you would have to accept the
certificate as trusted.

--
Regards,
Tom Ogilvy

"Bafa" <[email protected]> wrote in message
news:[email protected]...
>
> How do I set my file so that Excel does not ask me to enable macros
> every time I start up this workbook I am making? I cannot change the
> security settings on my PC since this is a work computer and others use
> it.
>
> What I would like to do is set something in my file or some setting in
> my securty so that this one file I am working on is trusted and I am
> not constantly asked if I want to enable them or not. Thanks.
>
>
> --
> Bafa
> ------------------------------------------------------------------------
> Bafa's Profile:
> http://www.excelforum.com/member.php...o&userid=37748
> View this thread: http://www.excelforum.com/showthread...hreadid=574031
>

Tools|Macro|Security|Low

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"Bafa" wrote:
|
| How do I set my file so that Excel does not ask me to enable macros
| every time I start up this workbook I am making? I cannot change the
| security settings on my PC since this is a work computer and others use
| it.
|
| What I would like to do is set something in my file or some setting in
| my securty so that this one file I am working on is trusted and I am
| not constantly asked if I want to enable them or not. Thanks.
|
|
| --
| Bafa
| ------------------------------------------------------------------------
| Bafa's Profile:
http://www.excelforum.com/member.php...o&userid=37748
| View this thread: http://www.excelforum.com/showthread...hreadid=574031
|

Oops, misread. Please disregard.

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

Bafa, how about making a digital certificate for the file? Here is a post by
Gord Dibben on the subject

You can create a digital certificate and use that on your VBAProject so only
that file with the certificate is allowed to be opened with no warning.


You can get to SelfCert either of these ways........


1. Start>Programs>Microsoft Office>Tools>"Digital Certificate for VBA
Projects"


2. Open Windows Explorer and drill down to your Office folder. Find
SelfCert.exe and run it.


This certificate is good only on your computer but can be used for more than
one file.

Once the certificate has been created and with your file open, go to the
VBEditor and select your VBAproject/file.

Tools>Digital Signature>Choose. Select the Certificate you just created.

OK your way out and save your file.

Next time you open this particular file you will not get the warning.

Gord Dibben Excel MVP




--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Bafa" <[email protected]> wrote in message
news:[email protected]...
>
> How do I set my file so that Excel does not ask me to enable macros
> every time I start up this workbook I am making? I cannot change the
> security settings on my PC since this is a work computer and others use
> it.
>
> What I would like to do is set something in my file or some setting in
> my securty so that this one file I am working on is trusted and I am
> not constantly asked if I want to enable them or not. Thanks.
>
>
> --
> Bafa
> ------------------------------------------------------------------------
> Bafa's Profile:
http://www.excelforum.com/member.php...o&userid=37748
> View this thread: http://www.excelforum.com/showthread...hreadid=574031
>

I started working on a new project and came back to read this info. I am surprised I didn't post a thank you. I can only guess I must have errored out on the post or something of that nature, because I really liked to certificate idea. I know this thread is very old, but this info came in very handy and I did want to thank you for it! Better late than never