Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
mandatory cell
i want my colleagues to mandatory fill in a cell before saving. is
this possible? (sorry for my poor english) thanks bta |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
mandatory cell
bta,
Copy the code below, and paste it into the codemodule of the ThisWorkbook object. See http://www.mvps.org/dmcritchie/excel/event.htm if you are not familiar with event coding. This code will require cell A1 of Sheet1 be filled in before the file will be saved. HTH, Bernie MS Excel MVP Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) If Worksheets("Sheet1").Range("A1").Value = "" Then MsgBox "Fill in cell A1 on Sheet1 !!!!" Cancel = True MsgBox "File is not saved yet!" End If End Sub wrote in message ... i want my colleagues to mandatory fill in a cell before saving. is this possible? (sorry for my poor english) thanks bta |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mandatory cell | Excel Discussion (Misc queries) | |||
Cell to be mandatory fill in | Excel Discussion (Misc queries) | |||
Cell to be mandatory fill in | Excel Discussion (Misc queries) | |||
How can I make a cell mandatory? | Excel Discussion (Misc queries) | |||
Making Cell Entry Mandatory | Excel Discussion (Misc queries) |