Mandatory Cell Entry upon opening file

[Susan50500]

I am looking to do the following:
When user opens the excel file, a pop up tells them they have to fill out cells A1, A2, A3 (as an example) in order to move on to any other work in the file. Then, the user is forced to complete cells A1, A2, and A3. Once fields are complete, all other cells are editable.

To further complicate....if they open the file and this information is already complete (saved from a previous version, for example.) I would want them to confirm that the data already in cells A1, A2, and A3 is correct.

 

[Yongle]

Welcome to the forum @Susan50500

Are cells A1, A2 & A3 located in the first sheet in the workbook ?

What type of value goes in each cell ?
- number? date? text ?

Is data validation currently used on any of those 3 cells?

What happens if user does not do as told ?
- close workbook without saving after 1st attempt ?
(encorages users to get things right first time)

 

[Jeffrey Mahoney]

Yongle has good questions.

I would hide all other sheets except for the sheet with the values you need confirmed. Once they confirm the values, All the other sheets become visible. You can hide the sheet upon close, thus when it's opened again, they are forced to enter the values.

 

[Yongle]

3 further questions ...

Is the sheet (containing the values to be entered in A1:A3) protected ?

After confirming values in A1:A3 should the user stay on the same sheet or be directed elsewhere ?

 

[Jeffrey Mahoney]

Well Yongle, it appears that the tourist went home. Either that or a strong wind at our faces has prevented our words to be heard.

It appears that our start dates our close. It looks like I have some catching up to do as far as the number of posts are concerned. I had another account prior to this one, but it got messed up.

 

[Yongle]

I have some catching up to do as far as the number of posts are concerned

@Jeffrey Mahoney - quality matters more than quantity. I suspect yours are more considered than mine

I expect that @Susan50500 was expecting to wait a little longer for an answer. She will be calling by again sometime soon.