View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default need logging before closing the workbook.

Hi
forgot to add some points:
- The logging workbook has to exist - otherwise an error would occur
- The logging workbook should not contain any macros (as this could -
depending on the security settings - cause a warning dialog)
- You may add a check that the maximum row limit of 65536 rows is not
exceeded

On a side-note: Depending oy your company / country this kind of
logging could require that employees are informed about this activity
logging (at least in Germany this would be the case / and employee
delegates have to be informed)!. Sou you may check your specific legal
restrictions for doing this!!


--
Regards
Frank Kabel
Frankfurt, Germany