Mandatory cell while sheet protected but without macro?

[Hai]

Hi all,

It sounds very difficult but Is there any way to make some cells mandatory while the sheet and workbook are protected (with password) and even when macro disabled?

Thanks in advance?

Hai

 

[Stormseed]

Not possible, as far as I know. I really understand, "mandatory" would be - not allowing the user to close the workbook unless he puts an entry in the cell.

You can however use VBA in order to make a cell mandatory in a worksheet. You can add up the code of protecting and unprotecting the worksheet with VBA itself. Nevertheless, with macros disabled, I dont think it is possible to make a cell mandatory.

 

[DonkeyOte]

Stormseed is correct... unfortunately the only option open to you without VBA would be data validation but because data validation only fires on data entry the end user navigating to another cell does not invoke the validation (also the cell would have to be unlocked if the remainder of the sheet were protected) ... if it did fire on selection change (ie moving away from the cell forced entry validation) you could then of course save the file with the required cell activated then regardless of whether or not user enabled VBA they would be stuck on that cell and would have to enter something... sadly can not be done

There are posts around here that show ways of handling the possibility of end-users not enabling VBA and how to ensure the file is only ever used with VBA active... you can't force enabled macros but you can pretty much ensure that the user can only use the file if they have enabled macros by ensuring all sheets other than an instructions sheet ("how to enable macros") are xlveryhidden if VBA disabled... else if enabled the instruction sheet is xlveryhidden and the other sheets are all visible -- this IMO is the most common approach to this issue.

 

[Hai]

Tks a lot Stormseed and lasw10!

I'll just leave the idea for now then