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

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

--
Baf
-----------------------------------------------------------------------
Bafa's Profile: http://www.excelforum.com/member.php...fo&userid=3774
View this thread: http://www.excelforum.com/showthread.php?threadid=57403

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

--
Regards,
Tom Ogilvy

"Bafa" wrote in message
...

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. StartProgramsMicrosoft OfficeTools"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.

ToolsDigital SignatureChoose. 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" wrote in message
...

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