Thread: [Solved] How to check all cells before saving Workbook
View Single Post
 
Old 04-23-2013, 01:28 AM
beginner beginner is offline Windows 7 32bit Office 2007
Advanced Beginner
  
Join Date: Sep 2011
Location: Europe
Posts: 45
beginner will become famous soon enough
Question SOLVED: How to check all cells before saving Workbook
There on Sheet1 are not filled three cells, B9, B20 and G13
I need a VBA macro that when closing the workbook (in event Before_Save or Before_Close) will check whether all cells filled and alert users
Is possibility of this?
Attached Files
File Type: xls check-cells-before-save.xls (31.0 KB, 11 views)
Last edited by beginner; 04-25-2013 at 01:18 AM. Reason: SOLVED
Reply With Quote