Office wrecked my functions in a spreadsheet

  • Thread starter Thread starter Tommy Smith
  • Start date Start date
T

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?
 
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
 
...
...
Open Excel with any workbook.

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

Enable the disabled.
Click to expand...
...

!?

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?
 
no - I didn't know you had to and the tech folks never mentioned it. (I'll just redo 'em). Thanks
 
Back
Top