Thread: Cell Required Feild

Hi there,

My target is that I want to make cells as a required feild in sheet. User should not be able to save it until they fill in all the required feild on the sheet.

Can anyone please suggest how can I validate this rule on a specific feild.

Originally Posted by Bpatel

Hi there,

My target is that I want to make cells as a required feild in sheet. User should not be able to save it until they fill in all the required feild on the sheet.

Can anyone please suggest how can I validate this rule on a specific feild.

you'd have to use a macro using the beforesave event.

for this to work everytime the sheet is opened the user would have to enable macros. is this something that can be done?