wht is vb code to select a specific worksheet every time you close a workbook?
that is, i need to active the active worksheet to be "CompiliedMaster" prior to closing the .xls. i still want the user to be prompted for the option of saving the file.
thanks
Terry
that is, i need to active the active worksheet to be "CompiliedMaster" prior to closing the .xls. i still want the user to be prompted for the option of saving the file.
thanks
Terry