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.

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

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

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