Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 04-23-2013, 01:28 AM
beginner beginner is offline How to check all cells before saving Workbook Windows 7 32bit How to check all cells before saving Workbook Office 2007
Advanced Beginner
How to check all cells before saving Workbook
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to check all cells before saving Workbook cannot check/uncheck check box but added check box learn2office Word 1 11-27-2012 02:02 AM
How to check all cells before saving Workbook #REF! error when opening a workbook that contain a refference to another workbook tanababa Excel 2 06-07-2012 03:11 PM
Range(Cell1,Cell2) Error on another workbook controlling some other workbook? tinfanide Excel Programming 1 02-09-2012 04:08 PM
How to check all cells before saving Workbook macro to transfer data from one workbook to another workbook virsojour Excel Programming 5 02-01-2011 08:58 PM
How to check all cells before saving Workbook Select a range in one one workbook while working in other workbook Slow&Steady Excel 1 02-21-2010 03:34 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:39 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft