Finally... Thanks for the response(s).... I nailed it...
I was trying to figure out why the sheet1.select feature wasn't working.
I was not using the correct sheet name of all things. As I am still somewhat of a novice, the "tabname" and "sheet name" are different. I was using the "tab" name incorrectly. So Sheet1.select wouldn't work but sheet27.select in a macro of the Before_close module works great. Wherever I am in the program, upon close, the program defaults to "Sheet1". Maybe this will be helpful to other users to remember to correctly use the proper names defined for each sheet.
Perhaps I could get an understanding sometime of how the tabname and sheet name differ with regard to VBA. I honestly don't recall naming these sheets(sheet27) when I built this program a while back. How does each sheet get a respective "name" in VBA also can this be changed?
Thanks for all the help