I had a fully funcitonal vba program - that as the file is close - it appends a couple lines to the next open row.... based upon the "thisworkbook.workbook_beforeclose" routine - it opens a sub in a module - which depending on how they have filled out the forum - it adds lines t


I made a modification to allow me to acquire one more piece of data if the user has not already provided it...

Now when it returns to the "PREVIOUS fully functional sub" it behaves as follows
a) I can read (debug.print) activeworkbook.name
b) I can read (debug.print) activesheet.name
C) I can read (debug.print) activecell.row / column
d) I can send values to specfic cells on the sheet (ie Range("A1000").value = "LAST CELL"
e) I can move around on the cell (arrows) and verify where on the sheet I am...

BUT
I can not select/activate a cell
Range("A1000").select -----does not move
cells.select ------does nothing
activecell.offset(1,1).activate ------- does nothing
activecell.offset.font.italic = true -------- does nothing
EVEN right clicking on any cell on the sheet and clicking Format Cells - does NOT call up the dialog box (ironically when I change to another sheet on the current workbook - I CAN call up the Dialog box for Format Cells)

WHAT HAVE I DONE???
HOW DO I FIX