| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
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
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
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
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
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
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
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
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
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
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
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
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Enable Macros question at Startup | Excel Discussion (Misc queries) | |||
| how to enable macros | Excel Discussion (Misc queries) | |||
| Enable macros? | Excel Worksheet Functions | |||
| Enable macros automatically for a workbook | Excel Discussion (Misc queries) | |||
| macros enable | New Users to Excel | |||
Linear Mode
