Cleaning Off Tyre Marks

Amendment

This post will show how to change the messages displayed in the statusbar of Excel, for this employ a bit of code that is inserted into ThisWorkbook.

The example show will cause the triggering of an excel sheet in Statusbar the following message: ' Sheet sheetname activated', the code must be entered within ThisWorkbook to this press ALT + F11 and select the name, as shown in the picture:

Within this we must add code to the event SheetActivate of Workbook, then the first step is to select Workbook, further indicating the figure below and then select statements SheetActivate .

The SheetActivate code inside should look like:



It should be noted that the argument passed to SheetActivate the sheet is active within the code so you can use the property of 'Sh'.

This completes the exercise, you can try changing the blade and modified the message in the statusbar. Here you can download the example shown.