It appears that somewhere in my VBA code I have disabled a few basic features
of Excel. It appears that my Recent File List in Excel is not getting
updated. As well, when I copy from one sheet to another, it is pasting the
values and not the function that is entered in the original file. Please
help. What command(s) would cause these, and what command could I enter in
the Immediate window to restore the original "values?"

Okay, I may have fixed one of the two problems... I will see once I logout
and log back in if my recent files list gets updated to the current list of
recent files.

I also have additional information about my copy and paste problem. It
appears that if I copy a cell that has a formula from one workbook and then
try to paste that cell in a different workbook, that I only get the result
pasted, not the formula. When I try to do a pastespecial I get a Paste a
window that indicates that it trying to paste say a Microsoft Excel Worksheet
Object, Picture (Enhanced Metafile), Bitmap, etc... Not the typical
Formulas, Values, Formats, etc...

Has me perplexed... Any ideas why this is happening/how to fix it?


"GB" wrote:

It appears that somewhere in my VBA code I have disabled a few basic features
of Excel. It appears that my Recent File List in Excel is not getting
updated. As well, when I copy from one sheet to another, it is pasting the
values and not the function that is entered in the original file. Please
help. What command(s) would cause these, and what command could I enter in
the Immediate window to restore the original "values?"