How to show a (pop up) message without VBA?

[hond70]

Hi there,

Is there a way to show a pop up or a message based on a cell value each time the user opens the Excel file?
Preferably they see it no matter where they were when they saved the file.

Limitations:
- No VBA!!!!
- Users must not be able to alter or delete the message
- Users must be able to enter values in each sheet, and to add rows and columns

In place:
- Excel file is password protected (only the structure) to hide certain sheets with restricted data
- The cell that triggers the message (box) is in a hidden sheet
- When the user enters a certain code at a designated place, the hidden cell changes and the message should disappear

Of course I can protect the cells (row 1) where I place the message and leave all other cells unprotected. But unlike the file protection, the sheet protection is not secure. And I would have to place the message in each sheet. So is there another way?

 

[Logit]

.
I belive you will need to use VBA to accomplish your goal. A formula will present the same information but without VBA the message will always remain.

Review this link for examples : https://www.extendoffice.com/documents/excel/2516-excel-warning-if-cell-is-blank.html


You can also use a UserForm instead of a message box, but again ... you will need to use VBA to display and hide the userform.


If there is a way to accomplish the task without VBA ... I am not aware but would be interested in learning.

 

[MARK858]

But unlike the file protection, the sheet protection is not secure

A bit worrying that you think Excel's file protection is secure

 

[Logit]

A bit worrying that you think Excel's file protection is secure

Thanks Mark858 ... you bring up another attribute inherent with Excel.