Alert Box

Hi all,

I have recorded a macro that extracts a worksheet and places it in a new documents. Can anyone advise me of the VBA I need to put at the end of the code so that an alert box will pop up saying something like "You must now save this spreadsheet" and an "OK" button.

TIA,

SamuelT

Originally Posted by SamuelT

Hi all,

I have recorded a macro that extracts a worksheet and places it in a new documents. Can anyone advise me of the VBA I need to put at the end of the code so that an alert box will pop up saying something like "You must now save this spreadsheet" and an "OK" button.

TIA,

SamuelT

Include at the appropriate point in your code

Msgbox "You must now save this spreadsheet"

---

Please Login or Register  to view this content.

Brilliant - thanks Bryan!