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?
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.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.