Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Enable/Disable Macros..Excel
Name: halenhardy Date: January 21, 2004 at 06:48:48 Pacific OS: WindowsXP CPU/Ram: Pent 128m
Comment:
I installed MSoffice 2000 on a laptop with WindowsXP Pro I recently purchased. I copied an Excel file from my Desktop WindowsME system to the laptop. This file has much Macro & Visual Basic code. When I activate the file I get a message box saying the file contans Macros. Then it has 3 options. "Delete Macros" "Enable Macros" & More info. Does anyone know how I can get rid of this message box. Thanks Gary Hardy
Name: chnos Date: January 21, 2004 at 08:03:27 Pacific
Reply:
tools/macro/protection. Set level to mid or low. Hope it helps u
0
Response Number 2
Name: Report_2 Date: January 21, 2004 at 14:21:26 Pacific
Reply:
Another way is to digitally sign the macros you want to be marked as 'Safe'. Found in VBE Tools.
Then you can elect to mark all macros signed by you (or anyone else you choose) as safe. You won't be asked again on those.
HTH Bryan
0
Response Number 3
Name: colors Date: January 21, 2004 at 16:59:51 Pacific
Reply:
I get the same macro message in word97 so how do I or can I set the level to mid or low?
As always thanks!
0
Response Number 4
Name: chnos Date: January 21, 2004 at 23:05:56 Pacific
Reply:
do the same . If needed add it to ur menu
0
Response Number 5
Name: colors Date: January 22, 2004 at 18:41:03 Pacific
Reply:
My only options are tools/macro/macros ALT+8, Record New Macro and Visual Basic Editor ALT+F11. So I guess I don't understand your response?
0
Response Number 6
Name: halenhardy Date: January 22, 2004 at 20:18:14 Pacific
Reply:
Taxi / Bryan.. I discovered the tools/macro/security options after I had entered my problem. I sent 2 replies but it seems they got lost. Thanks for your suggestions. Gary
0
Response Number 7
Name: colors Date: January 23, 2004 at 07:30:19 Pacific
Reply:
Gary, Sorry for taking over your post I thought your question was answered.
0
Response Number 8
Name: chnos Date: January 24, 2004 at 00:41:31 Pacific
Reply:
right clic on toolbar/custom and insert the security/macro icon in ur macro menu...
0
Response Number 9
Name: colors Date: January 24, 2004 at 08:12:11 Pacific
Reply:
I was playing around with the security option and now it's gone. How do I get it back?
0
Response Number 10
Name: chnos Date: January 25, 2004 at 06:37:02 Pacific
Reply:
see advice : right clic on toolbar, choose custom and search for the security icon, in the icon list, (in the tool /chapter).select it (left clic) and put it in ur toolbar or tool/macro menu.
0
Response Number 11
Name: colors Date: January 25, 2004 at 07:45:26 Pacific
Reply:
I got to the dragging part when I was interrupted so I dragged it back to it's original position and closed out the window. Then went back in and security was gone. I was able to drag properties without a problem. I have booted up 3 times and still no security option. How could I have lost the option.
0
Response Number 12
Name: chnos Date: January 26, 2004 at 09:39:11 Pacific
Reply:
did u tried to restore the standard toolbar to default..?u browse til u find predefined menu and take the 'tool' one and reput it in ur toolbar.
0
Response Number 13
Name: colors Date: January 26, 2004 at 18:09:02 Pacific
Reply:
Taxi, Thanks for posting back! I think I will leave this 'new headache' well enough alone.
0
Response Number 14
Name: qimel Date: February 13, 2004 at 06:48:16 Pacific
Reply:
How do I delete a macro from an excel workbook so it no longer is associated? I thought I accomplished this, but the dialoge box asking to enable/disable the macro still pops up everytime I open the workbook, even though it there is no macro listed for the workbook ??????? Thanks.
Summary: My Excel 2000 workbook, on Windows 98, seems to contain no macros, according to a check of "Macro... ." I know the workbook did have macros a long time ago, but they seem to be gone; I believe I dele...
Summary: How does one disable the messages that appear when opening an excel spread sheet? I have users that access a list of spreadsheets on an intranet and I am sick of complaints asking to disable the warni...
0 
configurating mswords
