Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Security Drop Down
-Running Excel 2000 with Win XP Pro
-Recently had to reformat and since Office 2000 was an upgrade, loaded Office 97 then loaded 2k. -Problem: The security tab is not even in the macro menu drop down so I cannot change macro security. -I am the only user on this computer, and am signed on as the administrator. -Norton AV script blocking off/on has no effect. Any help would be appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Security Drop Down
Just a guess, but in C:\Documents and Settings\-your name-\Application Data\Microsoft\Excel is a .xlb file, with Excel closed, rename that to *.xl97 and re-open Excel 2003 or from the Start - select Run Excel.exe /regserver and let me know if this helps. -- Mike S Wrote: -Running Excel 2000 with Win XP Pro -Recently had to reformat and since Office 2000 was an upgrade, loaded Office 97 then loaded 2k. -Problem: The security tab is not even in the macro menu drop down so I cannot change macro security. -I am the only user on this computer, and am signed on as the administrator. -Norton AV script blocking off/on has no effect. Any help would be appreciated. -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=536240 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Security Drop Down
That did it, but is there a way to combine the two Excel.xlb files so I don't
lose all my custom toolbars & buttons? Some of the buttons go back to XL95. Or, will I have to manually redo them all? Thanks for your help. "Bryan Hessey" wrote: Just a guess, but in C:\Documents and Settings\-your name-\Application Data\Microsoft\Excel is a .xlb file, with Excel closed, rename that to *.xl97 and re-open Excel 2003 or from the Start - select Run Excel.exe /regserver and let me know if this helps. -- Mike S Wrote: -Running Excel 2000 with Win XP Pro -Recently had to reformat and since Office 2000 was an upgrade, loaded Office 97 then loaded 2k. -Problem: The security tab is not even in the macro menu drop down so I cannot change macro security. -I am the only user on this computer, and am signed on as the administrator. -Norton AV script blocking off/on has no effect. Any help would be appreciated. -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=536240 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Security Drop Down
If they go back to XL95 then I would reccommend a re-do, and if possible setup as a macro, this way you can re-set them should you have a need to remove the .xlb file to reset Defaults in the future. -- HTH -- Mike S Wrote: That did it, but is there a way to combine the two Excel.xlb files so I don't lose all my custom toolbars & buttons? Some of the buttons go back to XL95. Or, will I have to manually redo them all? Thanks for your help. "Bryan Hessey" wrote: Just a guess, but in C:\Documents and Settings\-your name-\Application Data\Microsoft\Excel is a .xlb file, with Excel closed, rename that to *.xl97 and re-open Excel 2003 or from the Start - select Run Excel.exe /regserver and let me know if this helps. -- Mike S Wrote: -Running Excel 2000 with Win XP Pro -Recently had to reformat and since Office 2000 was an upgrade, loaded Office 97 then loaded 2k. -Problem: The security tab is not even in the macro menu drop down so I cannot change macro security. -I am the only user on this computer, and am signed on as the administrator. -Norton AV script blocking off/on has no effect. Any help would be appreciated. -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=536240 -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=536240 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro security level in excel will not change | Excel Discussion (Misc queries) | |||
Macro Security | Setting up and Configuration of Excel | |||
Disable macro security for selected workbook | Excel Discussion (Misc queries) | |||
Setting macro security level to "low" permanently? | Excel Discussion (Misc queries) | |||
Removing Unnecessary Macro Security Warnings | Excel Discussion (Misc queries) |