RichardFrench
New Member
- Joined
- Feb 4, 2014
- Messages
- 5
I am a volunteer firefighter attempting to create a spreadsheet workbook to be used every Saturday night by our bingo cashier. I modeled the workbook after the original paperwork because I thought it would be easier for the users to input the data needed.
The usual course of action is to open the workbook and per my instructions immediately save it as a new workbook with the current evenings date and title. However, there are 4 to 8 different people using this workbook. Because we run a different bingo crew every weekend. My problem is that sometimes they forget to save the workbook as a new document, thereby overwriting the original.
I have managed to introduce a pop-up window requiring them to click okay before they continue. The window pops up when this workbook is opened. But I would like to find a way to automatically save this document Upon being opened as a new document. Or a way to use a pop up a dialog box that would do it when the user clicks yes.
I would appreciate and consider all responses.
Just a side note: I have over 100 hours into creating this workbook. Prior to doing this I had never done anything more complicated than a check ledger in Excel. And now I find myself looking constantly for ways to improve it.
The usual course of action is to open the workbook and per my instructions immediately save it as a new workbook with the current evenings date and title. However, there are 4 to 8 different people using this workbook. Because we run a different bingo crew every weekend. My problem is that sometimes they forget to save the workbook as a new document, thereby overwriting the original.
I have managed to introduce a pop-up window requiring them to click okay before they continue. The window pops up when this workbook is opened. But I would like to find a way to automatically save this document Upon being opened as a new document. Or a way to use a pop up a dialog box that would do it when the user clicks yes.
I would appreciate and consider all responses.
Just a side note: I have over 100 hours into creating this workbook. Prior to doing this I had never done anything more complicated than a check ledger in Excel. And now I find myself looking constantly for ways to improve it.
