Pop-Up Reminder

[SharonJo]

Each time I issue a new report I just copy the report and paste it into a new worksheet--but sometimes I forget and just start editing! Is there a way to have some kind of a pop-up reminder when I open the workbook?

 

[Andrew Fergus]

Hi Sharon

Use the following code to prompt you every time you open the workbook:

Private Sub Workbook_Open()

MsgBox "Don't forget to copy the data into a new worksheet!", vbInformation, "Caution!"

End Sub

Change the message to suit. Just ask if you aren't sure how to use this code.

Andrew

 

[SharonJo]

Thank you, it looks perfect, but I do not know how to use it.

 

[Andrew Fergus]

Hi

Open your spreadsheet, press the Alt and the F11 keys at the same time - this will open the VBA editor. Under the heading 'Project' on the left hand pane, locate your spreadsheet (by name) and under your spreadsheet name will be a number Sheets listed under the heading 'VBAProject', double click the one that says 'ThisWorkbook' (it will be the last one in the list under the spreadsheet name), and then copy>paste the code I supplied into the large white pane on the right hand side. Save and close the VBA editor. Save and close the spreadsheet. Reopen the spreadsheet to test.

Just ask if you get stuck.

HTH, Andrew

 

[SharonJo]

It works perfect! Thank you.