PC Review


Reply
Thread Tools Rate Thread

Digitally Signed Macros in Personal.XLS

 
 
cvgairport
Guest
Posts: n/a
 
      22nd Jul 2009
All -

I am trying to get rid of those annoying warning boxes when I open a
spreadsheet and want to run a macro stored in my personal.xls file. I have
gone into my personal.xls file and digitally signed the spreadsheet but I
can't now go into any other spreadsheet and get the macro in my global
personal.xls spreadsheet to run. I think I need to load myself as a trusted
source but the "add as trusted sources" check box does not appear. And does
it mean I have to add myself as a trusted source to every spreadsheet I ever
run to use the macros in my personal.xls file?

Help!

Amy
 
Reply With Quote
 
 
 
 
JLGWhiz
Guest
Posts: n/a
 
      22nd Jul 2009
Or lower your security settings.


"cvgairport" <(E-Mail Removed)> wrote in message
news:6AE667A7-E61B-41F7-B9FB-(E-Mail Removed)...
> All -
>
> I am trying to get rid of those annoying warning boxes when I open a
> spreadsheet and want to run a macro stored in my personal.xls file. I
> have
> gone into my personal.xls file and digitally signed the spreadsheet but I
> can't now go into any other spreadsheet and get the macro in my global
> personal.xls spreadsheet to run. I think I need to load myself as a
> trusted
> source but the "add as trusted sources" check box does not appear. And
> does
> it mean I have to add myself as a trusted source to every spreadsheet I
> ever
> run to use the macros in my personal.xls file?
>
> Help!
>
> Amy



 
Reply With Quote
 
cvgairport
Guest
Posts: n/a
 
      22nd Jul 2009
Isn't that dangerous?

"JLGWhiz" wrote:

> Or lower your security settings.
>
>
> "cvgairport" <(E-Mail Removed)> wrote in message
> news:6AE667A7-E61B-41F7-B9FB-(E-Mail Removed)...
> > All -
> >
> > I am trying to get rid of those annoying warning boxes when I open a
> > spreadsheet and want to run a macro stored in my personal.xls file. I
> > have
> > gone into my personal.xls file and digitally signed the spreadsheet but I
> > can't now go into any other spreadsheet and get the macro in my global
> > personal.xls spreadsheet to run. I think I need to load myself as a
> > trusted
> > source but the "add as trusted sources" check box does not appear. And
> > does
> > it mean I have to add myself as a trusted source to every spreadsheet I
> > ever
> > run to use the macros in my personal.xls file?
> >
> > Help!
> >
> > Amy

>
>
>

 
Reply With Quote
 
JLGWhiz
Guest
Posts: n/a
 
      22nd Jul 2009
If you mean would that subject your files to virus, the answer is yes. But
if you have virus protection on your system, you still have some protection,
and most virus attack the operating system rather than specific files. You
have to weigh the advantage of having the messages dissapear to probability
of virus.


"cvgairport" <(E-Mail Removed)> wrote in message
news:687ACE1C-0700-4C07-9B52-(E-Mail Removed)...
> Isn't that dangerous?
>
> "JLGWhiz" wrote:
>
>> Or lower your security settings.
>>
>>
>> "cvgairport" <(E-Mail Removed)> wrote in message
>> news:6AE667A7-E61B-41F7-B9FB-(E-Mail Removed)...
>> > All -
>> >
>> > I am trying to get rid of those annoying warning boxes when I open a
>> > spreadsheet and want to run a macro stored in my personal.xls file. I
>> > have
>> > gone into my personal.xls file and digitally signed the spreadsheet but
>> > I
>> > can't now go into any other spreadsheet and get the macro in my global
>> > personal.xls spreadsheet to run. I think I need to load myself as a
>> > trusted
>> > source but the "add as trusted sources" check box does not appear. And
>> > does
>> > it mean I have to add myself as a trusted source to every spreadsheet I
>> > ever
>> > run to use the macros in my personal.xls file?
>> >
>> > Help!
>> >
>> > Amy

>>
>>
>>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Distribute Digitally Signed (selfcert used to sign) Macros to othe DStrong Microsoft Outlook VBA Programming 2 29th Jul 2010 06:58 PM
digitally signed macros Brian Microsoft Excel Discussion 1 18th Jul 2008 08:59 PM
xp digitally signed drivers show as not signed when installing jamesph Windows XP Help 2 12th May 2008 07:09 PM
Digitally signed Aaron Microsoft Dot NET 1 4th Apr 2005 03:49 PM
Digitally Signed Macros Roscoe Microsoft Excel Discussion 2 25th Jan 2005 01:34 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:07 PM.