no macro warning!

Todd_M · Mar 12th, 2002, 12:57 PM

Hi
How do you stop the macro warning msgbox showing everytime Im about open a workbook containing macros?

Steve Hartman · Mar 12th, 2002, 01:02 PM

Go to TOOLS > MACRO > SECURITY. You can change the setting there.

charlie79 · Mar 12th, 2002, 01:05 PM

I was browsing and this topic caught my eye. I realize that to be a solution, however, what if I don't want to change a users setting so that it won't prompt all of the time. I want it to not prompt only for my app. Any ideas?

Todd_M · Mar 12th, 2002, 01:13 PM

Thats what I would think too! Idont want to sacrfice every program, just this one!!

tk19 · Mar 12th, 2002, 01:56 PM

Don't forget, the whole point of a macro warning is so someone is warned of the possibility the macro contains a virus. If someone wishes to be forewarned of a spreadsheet that has a macro, do you really think you should be trying to get around it?

Von Pookie · Mar 12th, 2002, 02:00 PM

Quote:

On 2002-03-12 12:56, tk19 wrote:
Don't forget, the whole point of a macro warning is so someone is warned of the possibility the macro contains a virus. If someone wishes to be forewarned of a spreadsheet that has a macro, do you really think you should be trying to get around it?

It depends. Yes, it is a good idea to leave it alone, especially if you're downloading stuff.

However, if you wrote the macro yourself and/or you are the only person who uses the workbook (which is the scenario for me), then it can become very tiring to see it every single time.

_________________
"What am I, a magnet for these idiots?"
--Pearl Forrester, MST3K

[ This Message was edited by: Von Pookie on 2002-03-12 13:01 ]

Russell Hauf · Mar 12th, 2002, 02:01 PM

If you are using Excel 97, you can password protect the workbook (when saving), and it won't ask to enable macros when opened. It will, however, ask for a password.

I don't think the case is the same in XL 2K.

-rh

Mark O'Brien · Mar 12th, 2002, 02:24 PM

In XL 2000 you can add a digital signature. I've never used this so you'll need to look at Help for more on this, but basically the digital signature tells XL that the file is from a trusted source and not some pre-pubescent pleb that copied some malicious code from the internet.

Todd_M · Mar 12th, 2002, 03:32 PM

Yes, you beat me to it mark, You have to install the digital signatures from the office disk (features/office tools/digital signture for vba, click arrow/run my comp)

Then find the file c:/program files/microsoft office/office and click on self cert.exe and list your name

Then go to v.b. and click on the workbook your using and choose tools/digital signatures/choose/ok/ok.

Last close program (save it), reopen it and it will promp you one last time, check off the checkbox and your all set!!!

Russell Hauf · Mar 12th, 2002, 03:42 PM

Is it me, or is that scary? How does this prevent "some pre-pubescent pleb that copied some malicious code from the internet" (Mark O'Brien's words, not mine) from creating his/her own signature?

Maybe it stores some of your computer's info? Todd, did you have to register anything online or anything like that?

Mar 12th, 2002, 02:24 PM	#8
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	In XL 2000 you can add a digital signature. I've never used this so you'll need to look at Help for more on this, but basically the digital signature tells XL that the file is from a trusted source and not some pre-pubescent pleb that copied some malicious code from the internet. __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 12th, 2002, 12:57 PM	#1
Todd_M Board Regular Join Date: Feb 2002 Posts: 117	Hi How do you stop the macro warning msgbox showing everytime Im about open a workbook containing macros?

Mar 12th, 2002, 01:02 PM	#2
Steve Hartman Board Regular Join Date: Feb 2002 Location: Houston,Texas Posts: 418	Go to TOOLS > MACRO > SECURITY. You can change the setting there.

Mar 12th, 2002, 01:05 PM	#3
charlie79 Board Regular Join Date: Feb 2002 Posts: 97	I was browsing and this topic caught my eye. I realize that to be a solution, however, what if I don't want to change a users setting so that it won't prompt all of the time. I want it to not prompt only for my app. Any ideas?

Mar 12th, 2002, 01:13 PM	#4
Todd_M Board Regular Join Date: Feb 2002 Posts: 117	Thats what I would think too! Idont want to sacrfice every program, just this one!!

Mar 12th, 2002, 01:56 PM	#5
tk19 New Member Join Date: Mar 2002 Posts: 33	Don't forget, the whole point of a macro warning is so someone is warned of the possibility the macro contains a virus. If someone wishes to be forewarned of a spreadsheet that has a macro, do you really think you should be trying to get around it?

Mar 12th, 2002, 02:01 PM	#7
Russell Hauf MrExcel MVP Join Date: Feb 2002 Location: Portland, OR USA Posts: 1,374	If you are using Excel 97, you can password protect the workbook (when saving), and it won't ask to enable macros when opened. It will, however, ask for a password. I don't think the case is the same in XL 2K. -rh

Mar 12th, 2002, 03:32 PM	#9
Todd_M Board Regular Join Date: Feb 2002 Posts: 117	Yes, you beat me to it mark, You have to install the digital signatures from the office disk (features/office tools/digital signture for vba, click arrow/run my comp) Then find the file c:/program files/microsoft office/office and click on self cert.exe and list your name Then go to v.b. and click on the workbook your using and choose tools/digital signatures/choose/ok/ok. Last close program (save it), reopen it and it will promp you one last time, check off the checkbox and your all set!!!

Mar 12th, 2002, 03:42 PM	#10
Russell Hauf MrExcel MVP Join Date: Feb 2002 Location: Portland, OR USA Posts: 1,374	Is it me, or is that scary? How does this prevent "some pre-pubescent pleb that copied some malicious code from the internet" (Mark O'Brien's words, not mine) from creating his/her own signature? Maybe it stores some of your computer's info? Todd, did you have to register anything online or anything like that?