If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Macros copied to new PC won't enable
I have moved a workbook "Reports.xls" 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 "The macros in this project have been disabled" etc The Help file suggests this is due to the Security level of the 2000 version. It mentions going to "Tools, Macro, Security...." in Excel to change the setting. But this Excel [2000] does not have the "security.." extension to the Tool, Macro.." menus? Any advice appreciated Piri |
#2
|
|||
|
|||
Macros copied to new PC won't enable
It does on my machine. ?
Go to Tools--Customize, Options tab. Uncheck the top two checkboxes, and try Tools--Macro--Security again. Then, after you've set to Medium, re-open your workbook. ************ Hope it helps! Anne Troy www.OfficeArticles.com "Piri" wrote in message ... I have moved a workbook "Reports.xls" 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 "The macros in this project have been disabled" etc The Help file suggests this is due to the Security level of the 2000 version. It mentions going to "Tools, Macro, Security...." in Excel to change the setting. But this Excel [2000] does not have the "security.." extension to the Tool, Macro.." menus? Any advice appreciated Piri |
#3
|
|||
|
|||
Macros copied to new PC won't enable
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--Macro-- all I get is Macros... oRecord New Macro... --------------------- Visual Basic Editor There is nothing about "security" - 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, Piri Anne Troy wrote: It does on my machine. ? Go to Tools--Customize, Options tab. Uncheck the top two checkboxes, and try Tools--Macro--Security again. Then, after you've set to Medium, re-open your workbook. ************ Hope it helps! Anne Troy www.OfficeArticles.com "Piri" wrote in message ... I have moved a workbook "Reports.xls" 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 "The macros in this project have been disabled" etc The Help file suggests this is due to the Security level of the 2000 version. It mentions going to "Tools, Macro, Security...." in Excel to change the setting. But this Excel [2000] does not have the "security.." extension to the Tool, Macro.." menus? Any advice appreciated Piri |
#4
|
|||
|
|||
Macros copied to new PC won't enable
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--Run: excel.exe /regserver and see if that brings it back. ************ Hope it helps! Anne Troy www.OfficeArticles.com "Piri" wrote in message ... 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--Macro-- all I get is Macros... oRecord New Macro... --------------------- Visual Basic Editor There is nothing about "security" - 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, Piri Anne Troy wrote: It does on my machine. ? Go to Tools--Customize, Options tab. Uncheck the top two checkboxes, and try Tools--Macro--Security again. Then, after you've set to Medium, re-open your workbook. ************ Hope it helps! Anne Troy www.OfficeArticles.com "Piri" wrote in message ... I have moved a workbook "Reports.xls" 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 "The macros in this project have been disabled" etc The Help file suggests this is due to the Security level of the 2000 version. It mentions going to "Tools, Macro, Security...." in Excel to change the setting. But this Excel [2000] does not have the "security.." extension to the Tool, Macro.." menus? Any advice appreciated Piri |
#5
|
|||
|
|||
Macros copied to new PC won't enable
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. Piri Anne Troy wrote: 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--Run: excel.exe /regserver and see if that brings it back. ************ Hope it helps! Anne Troy www.OfficeArticles.com "Piri" wrote in message ... 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--Macro-- all I get is Macros... oRecord New Macro... --------------------- Visual Basic Editor There is nothing about "security" - 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, Piri Anne Troy wrote: It does on my machine. ? Go to Tools--Customize, Options tab. Uncheck the top two checkboxes, and try Tools--Macro--Security again. Then, after you've set to Medium, re-open your workbook. ************ Hope it helps! Anne Troy www.OfficeArticles.com "Piri" wrote in message .. . I have moved a workbook "Reports.xls" 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 "The macros in this project have been disabled" etc The Help file suggests this is due to the Security level of the 2000 version. It mentions going to "Tools, Macro, Security...." in Excel to change the setting. But this Excel [2000] does not have the "security.." extension to the Tool, Macro.." menus? Any advice appreciated Piri |
#6
|
|||
|
|||
Macros copied to new PC won't enable
No clue, Piri. I seldom waste my time trying to figure out "why".
************ Hope it helps! Anne Troy www.OfficeArticles.com Check out: www.ExcelUserConference.com "Piri" wrote in message ... 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. Piri Anne Troy wrote: 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--Run: excel.exe /regserver and see if that brings it back. ************ Hope it helps! Anne Troy www.OfficeArticles.com "Piri" wrote in message ... 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--Macro-- all I get is Macros... oRecord New Macro... --------------------- Visual Basic Editor There is nothing about "security" - 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, Piri Anne Troy wrote: It does on my machine. ? Go to Tools--Customize, Options tab. Uncheck the top two checkboxes, and try Tools--Macro--Security again. Then, after you've set to Medium, re-open your workbook. ************ Hope it helps! Anne Troy www.OfficeArticles.com "Piri" wrote in message . .. I have moved a workbook "Reports.xls" 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 "The macros in this project have been disabled" etc The Help file suggests this is due to the Security level of the 2000 version. It mentions going to "Tools, Macro, Security...." in Excel to change the setting. But this Excel [2000] does not have the "security.." extension to the Tool, Macro.." menus? Any advice appreciated Piri |
#7
|
|||
|
|||
Macros copied to new PC won't enable
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 "too much" 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. "Anne Troy" wrote: 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--Run: excel.exe /regserver and see if that brings it back. ************ Hope it helps! Anne Troy www.OfficeArticles.com "Piri" wrote in message ... 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--Macro-- all I get is Macros... oRecord New Macro... --------------------- Visual Basic Editor There is nothing about "security" - 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, Piri Anne Troy wrote: It does on my machine. ? Go to Tools--Customize, Options tab. Uncheck the top two checkboxes, and try Tools--Macro--Security again. Then, after you've set to Medium, re-open your workbook. ************ Hope it helps! Anne Troy www.OfficeArticles.com "Piri" wrote in message ... I have moved a workbook "Reports.xls" 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 "The macros in this project have been disabled" etc The Help file suggests this is due to the Security level of the 2000 version. It mentions going to "Tools, Macro, Security...." in Excel to change the setting. But this Excel [2000] does not have the "security.." extension to the Tool, Macro.." menus? Any advice appreciated Piri |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Where is menu option to enable macros? | dc1995 | General Discussion | 1 | January 19th, 2006 08:01 PM |
how to enable macros | Ollakal | General Discussion | 1 | October 19th, 2005 05:58 AM |
How do I enable macros? | Wyrm | General Discussion | 1 | May 21st, 2005 10:28 AM |
Automatically Enable Macros on specific Template | Bryan Linton | General Discussions | 2 | February 3rd, 2005 05:48 PM |
automatically enable macros | Lisa | Setting up and Configuration | 3 | March 23rd, 2004 11:16 PM |