Office wrecked my functions in a spreadsheet

[Tommy Smith]

I opened a file w/ functions in the new Office excel
program and the security was set high. It said it could
not open w/o signature or reducing security setting. I
closed the file and reduced the security to medium. Then
when I reopened the file and enabled the macros, I got a
message that the visual basic was lost and the function
cells showed NAME rather than the value. Now the file
cannot be opened with the functions and the function
cannot be displayed in the VB editor. It the file ruined?
Can I get the function back?

 

[Gord Dibben]

Tommy

Not wrecked, just disabled because you tried to open with High security.

Open Excel with any workbook.

Click on Help>About Microsoft Excel and click on "Disabled Items" button.

Enable the disabled.

Keep your security set at medium.

Retry your workbook with the Function code.

Gord Dibben Excel MVP

 

[Harlan Grove]

...
...

Open Excel with any workbook.

Click on Help>About Microsoft Excel and click on "Disabled Items" button.

Enable the disabled.

...

!?

It's under Help > About . . . ? [Rhetorical - I believe you.]

If the file were renamed, could it them be opened with macros enabled if
security were set to medium?

 

[Suzan]

I'm having the same problem due to upgrading to 2003. However, when I click Help, About Excel, I don't have a menu choice for 'disabled items'. If I go into Tools, Macros - one of the macros is still there; the other two are lost. However, I had toolbar buttons for all three and they are gone also.

 

[Lady Layla]

When you upgraded to 2003, did you copy your toolbar file and your personal.xls
file to a safe spot?



: I'm having the same problem due to upgrading to 2003. However, when I click
Help, About Excel, I don't have a menu choice for 'disabled items'. If I go into
Tools, Macros - one of the macros is still there; the other two are lost.
However, I had toolbar buttons for all three and they are gone also.

 

[Suzan]

no - I didn't know you had to and the tech folks never mentioned it. (I'll just redo 'em). Thanks