software

I have moved a workbook quot;Reports.xlsquot; created in Excel-97 containing
formatting macros from my PC to another on the network.

That PC has Office 2000 installed..

The macros will not run on the new location, citing quot;The macros in this
project have been disabledquot; etc

The Help file suggests this is due to the Security level of the 2000
version. It mentions going to quot;Tools, Macro, Security....quot; in Excel to
change the setting.
But this Excel [2000] does not have the quot;security..quot; extension to the
Tool, Macro..quot; menus?

Any advice appreciated

Piri

It does on my machine. ?
Go to Tools--gt;Customize, Options tab.
Uncheck the top two checkboxes, and try Tools--gt;Macro--gt;Security again.
Then, after you've set to Medium, re-open your workbook.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

quot;Piriquot; gt; wrote in message
...
gt;I have moved a workbook quot;Reports.xlsquot; created in Excel-97 containing
gt;formatting macros from my PC to another on the network.
gt;
gt; That PC has Office 2000 installed..
gt;
gt; The macros will not run on the new location, citing quot;The macros in this
gt; project have been disabledquot; etc
gt;
gt; The Help file suggests this is due to the Security level of the 2000
gt; version. It mentions going to quot;Tools, Macro, Security....quot; in Excel to
gt; change the setting.
gt; But this Excel [2000] does not have the quot;security..quot; extension to the
gt; Tool, Macro..quot; menus?
gt;
gt; Any advice appreciated
gt;
gt; Piri
Hello Anne,
Thanks for the reply.

Nope .... I have done what you suggest and nothing has changed.
The version of Excel is 2000 (9.0.6926 SP-3)
When I select Tools--gt;Macro--gt; all I get is
gt;Macros...
oRecord New Macro...
---------------------
Visual Basic Editor

There is nothing about quot;securityquot; - the menu looks just like my Excel
8.0 set-up.

Very frustrating.

I did not do the 2000 install and I wonder whether this issue may relate
to the whole Office install, IE security etc.

Cheers,
PiriAnne Troy wrote:
gt; It does on my machine. ?
gt; Go to Tools--gt;Customize, Options tab.
gt; Uncheck the top two checkboxes, and try Tools--gt;Macro--gt;Security again.
gt; Then, after you've set to Medium, re-open your workbook.
gt; ************
gt; Hope it helps!
gt; Anne Troy
gt; www.OfficeArticles.com
gt;
gt; quot;Piriquot; gt; wrote in message
gt; ...
gt;
gt;gt;I have moved a workbook quot;Reports.xlsquot; created in Excel-97 containing
gt;gt;formatting macros from my PC to another on the network.
gt;gt;
gt;gt;That PC has Office 2000 installed..
gt;gt;
gt;gt;The macros will not run on the new location, citing quot;The macros in this
gt;gt;project have been disabledquot; etc
gt;gt;
gt;gt;The Help file suggests this is due to the Security level of the 2000
gt;gt;version. It mentions going to quot;Tools, Macro, Security....quot; in Excel to
gt;gt;change the setting.
gt;gt;But this Excel [2000] does not have the quot;security..quot; extension to the
gt;gt;Tool, Macro..quot; menus?
gt;gt;
gt;gt;Any advice appreciated
gt;gt;
gt;gt;Piri
gt;
gt;
gt;

Are you at work? If so, perhaps they've disabled it so you cannot run
macros. I cannot imagine why else it would be missing. You could try
Start--gt;Run:
excel.exe /regserver
and see if that brings it back.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

quot;Piriquot; gt; wrote in message
...
gt; Hello Anne,
gt; Thanks for the reply.
gt;
gt; Nope .... I have done what you suggest and nothing has changed.
gt; The version of Excel is 2000 (9.0.6926 SP-3)
gt; When I select Tools--gt;Macro--gt; all I get is
gt; gt;Macros...
gt; oRecord New Macro...
gt; ---------------------
gt; Visual Basic Editor
gt;
gt; There is nothing about quot;securityquot; - the menu looks just like my Excel 8.0
gt; set-up.
gt;
gt; Very frustrating.
gt;
gt; I did not do the 2000 install and I wonder whether this issue may relate
gt; to the whole Office install, IE security etc.
gt;
gt; Cheers,
gt; Piri
gt;
gt;
gt;
gt;
gt;
gt; Anne Troy wrote:
gt;gt; It does on my machine. ?
gt;gt; Go to Tools--gt;Customize, Options tab.
gt;gt; Uncheck the top two checkboxes, and try Tools--gt;Macro--gt;Security again.
gt;gt; Then, after you've set to Medium, re-open your workbook.
gt;gt; ************
gt;gt; Hope it helps!
gt;gt; Anne Troy
gt;gt; www.OfficeArticles.com
gt;gt;
gt;gt; quot;Piriquot; gt; wrote in message
gt;gt; ...
gt;gt;
gt;gt;gt;I have moved a workbook quot;Reports.xlsquot; created in Excel-97 containing
gt;gt;gt;formatting macros from my PC to another on the network.
gt;gt;gt;
gt;gt;gt;That PC has Office 2000 installed..
gt;gt;gt;
gt;gt;gt;The macros will not run on the new location, citing quot;The macros in this
gt;gt;gt;project have been disabledquot; etc
gt;gt;gt;
gt;gt;gt;The Help file suggests this is due to the Security level of the 2000
gt;gt;gt;version. It mentions going to quot;Tools, Macro, Security....quot; in Excel to
gt;gt;gt;change the setting.
gt;gt;gt;But this Excel [2000] does not have the quot;security..quot; extension to the
gt;gt;gt;Tool, Macro..quot; menus?
gt;gt;gt;
gt;gt;gt;Any advice appreciated
gt;gt;gt;
gt;gt;gt;Piri
gt;gt;
gt;gt;I'm feeling little silly about this.
Googled a bit and came up with Reset of the Toolbars/ Menus.
That fixed the problem.

However, it does not explain why I needed to do that given it was a
brand new install of Excel 2000 on a new PC (Server).

Thanks for your help Anne.

PiriAnne Troy wrote:
gt; Are you at work? If so, perhaps they've disabled it so you cannot run
gt; macros. I cannot imagine why else it would be missing. You could try
gt; Start--gt;Run:
gt; excel.exe /regserver
gt; and see if that brings it back.
gt; ************
gt; Hope it helps!
gt; Anne Troy
gt; www.OfficeArticles.com
gt;
gt; quot;Piriquot; gt; wrote in message
gt; ...
gt;
gt;gt;Hello Anne,
gt;gt;Thanks for the reply.
gt;gt;
gt;gt;Nope .... I have done what you suggest and nothing has changed.
gt;gt;The version of Excel is 2000 (9.0.6926 SP-3)
gt;gt;When I select Tools--gt;Macro--gt; all I get is
gt;gt;
gt;gt;gt;Macros...
gt;gt;
gt;gt;oRecord New Macro...
gt;gt;---------------------
gt;gt;Visual Basic Editor
gt;gt;
gt;gt;There is nothing about quot;securityquot; - the menu looks just like my Excel 8.0
gt;gt;set-up.
gt;gt;
gt;gt;Very frustrating.
gt;gt;
gt;gt;I did not do the 2000 install and I wonder whether this issue may relate
gt;gt;to the whole Office install, IE security etc.
gt;gt;
gt;gt;Cheers,
gt;gt;Piri
gt;gt;
gt;gt;
gt;gt;
gt;gt;
gt;gt;
gt;gt;Anne Troy wrote:
gt;gt;
gt;gt;gt;It does on my machine. ?
gt;gt;gt;Go to Tools--gt;Customize, Options tab.
gt;gt;gt;Uncheck the top two checkboxes, and try Tools--gt;Macro--gt;Security again.
gt;gt;gt;Then, after you've set to Medium, re-open your workbook.
gt;gt;gt;************
gt;gt;gt;Hope it helps!
gt;gt;gt;Anne Troy
gt;gt;gt;www.OfficeArticles.com
gt;gt;gt;
gt;gt;gt;quot;Piriquot; gt; wrote in message
.. .
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;gt;I have moved a workbook quot;Reports.xlsquot; created in Excel-97 containing
gt;gt;gt;gt;formatting macros from my PC to another on the network.
gt;gt;gt;gt;
gt;gt;gt;gt;That PC has Office 2000 installed..
gt;gt;gt;gt;
gt;gt;gt;gt;The macros will not run on the new location, citing quot;The macros in this
gt;gt;gt;gt;project have been disabledquot; etc
gt;gt;gt;gt;
gt;gt;gt;gt;The Help file suggests this is due to the Security level of the 2000
gt;gt;gt;gt;version. It mentions going to quot;Tools, Macro, Security....quot; in Excel to
gt;gt;gt;gt;change the setting.
gt;gt;gt;gt;But this Excel [2000] does not have the quot;security..quot; extension to the
gt;gt;gt;gt;Tool, Macro..quot; menus?
gt;gt;gt;gt;
gt;gt;gt;gt;Any advice appreciated
gt;gt;gt;gt;
gt;gt;gt;gt;Piri
gt;gt;gt;
gt;gt;gt;
gt;

No clue, Piri. I seldom waste my time trying to figure out quot;whyquot;.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out: www.ExcelUserConference.com

quot;Piriquot; gt; wrote in message
...
gt; I'm feeling little silly about this.
gt; Googled a bit and came up with Reset of the Toolbars/ Menus.
gt; That fixed the problem.
gt;
gt; However, it does not explain why I needed to do that given it was a brand
gt; new install of Excel 2000 on a new PC (Server).
gt;
gt; Thanks for your help Anne.
gt;
gt; Piri
gt;
gt;
gt; Anne Troy wrote:
gt;gt; Are you at work? If so, perhaps they've disabled it so you cannot run
gt;gt; macros. I cannot imagine why else it would be missing. You could try
gt;gt; Start--gt;Run:
gt;gt; excel.exe /regserver
gt;gt; and see if that brings it back.
gt;gt; ************
gt;gt; Hope it helps!
gt;gt; Anne Troy
gt;gt; www.OfficeArticles.com
gt;gt;
gt;gt; quot;Piriquot; gt; wrote in message
gt;gt; ...
gt;gt;
gt;gt;gt;Hello Anne,
gt;gt;gt;Thanks for the reply.
gt;gt;gt;
gt;gt;gt;Nope .... I have done what you suggest and nothing has changed.
gt;gt;gt;The version of Excel is 2000 (9.0.6926 SP-3)
gt;gt;gt;When I select Tools--gt;Macro--gt; all I get is
gt;gt;gt;
gt;gt;gt;gt;Macros...
gt;gt;gt;
gt;gt;gt;oRecord New Macro...
gt;gt;gt;---------------------
gt;gt;gt;Visual Basic Editor
gt;gt;gt;
gt;gt;gt;There is nothing about quot;securityquot; - the menu looks just like my Excel
gt;gt;gt;8.0 set-up.
gt;gt;gt;
gt;gt;gt;Very frustrating.
gt;gt;gt;
gt;gt;gt;I did not do the 2000 install and I wonder whether this issue may relate
gt;gt;gt;to the whole Office install, IE security etc.
gt;gt;gt;
gt;gt;gt;Cheers,
gt;gt;gt;Piri
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;Anne Troy wrote:
gt;gt;gt;
gt;gt;gt;gt;It does on my machine. ?
gt;gt;gt;gt;Go to Tools--gt;Customize, Options tab.
gt;gt;gt;gt;Uncheck the top two checkboxes, and try Tools--gt;Macro--gt;Security again.
gt;gt;gt;gt;Then, after you've set to Medium, re-open your workbook.
gt;gt;gt;gt;************
gt;gt;gt;gt;Hope it helps!
gt;gt;gt;gt;Anne Troy
gt;gt;gt;gt;www.OfficeArticles.com
gt;gt;gt;gt;
gt;gt;gt;gt;quot;Piriquot; gt; wrote in message
. ..
gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;gt;gt;I have moved a workbook quot;Reports.xlsquot; created in Excel-97 containing
gt;gt;gt;gt;gt;formatting macros from my PC to another on the network.
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;That PC has Office 2000 installed..
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;The macros will not run on the new location, citing quot;The macros in this
gt;gt;gt;gt;gt;project have been disabledquot; etc
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;The Help file suggests this is due to the Security level of the 2000
gt;gt;gt;gt;gt;version. It mentions going to quot;Tools, Macro, Security....quot; in Excel to
gt;gt;gt;gt;gt;change the setting.
gt;gt;gt;gt;gt;But this Excel [2000] does not have the quot;security..quot; extension to the
gt;gt;gt;gt;gt;Tool, Macro..quot; menus?
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;Any advice appreciated
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;Piri
gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;
Ann,

I created a soreadsheet with macros in it. In my work environment most
users are not Admins on their boxes. I keep running into a requirement to
sign my macros, but that seems to involve buying a certificate for $$$ and
this is just quot;too muchquot; for the simple need I have!

How would I get my macros to work on those systems on Excel 2003? Pointers
to articles woudl be appreciated as well as direct answers.

quot;Anne Troyquot; wrote:

gt; Are you at work? If so, perhaps they've disabled it so you cannot run
gt; macros. I cannot imagine why else it would be missing. You could try
gt; Start--gt;Run:
gt; excel.exe /regserver
gt; and see if that brings it back.
gt; ************
gt; Hope it helps!
gt; Anne Troy
gt; www.OfficeArticles.com
gt;
gt; quot;Piriquot; gt; wrote in message
gt; ...
gt; gt; Hello Anne,
gt; gt; Thanks for the reply.
gt; gt;
gt; gt; Nope .... I have done what you suggest and nothing has changed.
gt; gt; The version of Excel is 2000 (9.0.6926 SP-3)
gt; gt; When I select Tools--gt;Macro--gt; all I get is
gt; gt; gt;Macros...
gt; gt; oRecord New Macro...
gt; gt; ---------------------
gt; gt; Visual Basic Editor
gt; gt;
gt; gt; There is nothing about quot;securityquot; - the menu looks just like my Excel 8.0
gt; gt; set-up.
gt; gt;
gt; gt; Very frustrating.
gt; gt;
gt; gt; I did not do the 2000 install and I wonder whether this issue may relate
gt; gt; to the whole Office install, IE security etc.
gt; gt;
gt; gt; Cheers,
gt; gt; Piri
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt; Anne Troy wrote:
gt; gt;gt; It does on my machine. ?
gt; gt;gt; Go to Tools--gt;Customize, Options tab.
gt; gt;gt; Uncheck the top two checkboxes, and try Tools--gt;Macro--gt;Security again.
gt; gt;gt; Then, after you've set to Medium, re-open your workbook.
gt; gt;gt; ************
gt; gt;gt; Hope it helps!
gt; gt;gt; Anne Troy
gt; gt;gt; www.OfficeArticles.com
gt; gt;gt;
gt; gt;gt; quot;Piriquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt;
gt; gt;gt;gt;I have moved a workbook quot;Reports.xlsquot; created in Excel-97 containing
gt; gt;gt;gt;formatting macros from my PC to another on the network.
gt; gt;gt;gt;
gt; gt;gt;gt;That PC has Office 2000 installed..
gt; gt;gt;gt;
gt; gt;gt;gt;The macros will not run on the new location, citing quot;The macros in this
gt; gt;gt;gt;project have been disabledquot; etc
gt; gt;gt;gt;
gt; gt;gt;gt;The Help file suggests this is due to the Security level of the 2000
gt; gt;gt;gt;version. It mentions going to quot;Tools, Macro, Security....quot; in Excel to
gt; gt;gt;gt;change the setting.
gt; gt;gt;gt;But this Excel [2000] does not have the quot;security..quot; extension to the
gt; gt;gt;gt;Tool, Macro..quot; menus?
gt; gt;gt;gt;
gt; gt;gt;gt;Any advice appreciated
gt; gt;gt;gt;
gt; gt;gt;gt;Piri
gt; gt;gt;
gt; gt;gt;
gt;
gt;