Recently I had a problem with my monitor: Samtron 94v. It was working fine but after 20 minutes of use, it went blank and showed me a message with:

Not optimum mode recommended mode: 1280×1024, 60Hz

I changed a lot of things in my systems. I even tried to upgrade Linux to the latest kernel - no use. So I searched the web and finally I found a report about someone who had the same problem. And he brought the monitor back to the agent, and he got his monitor repaired.

Due to the fact, that my monitor was still inside the warranty-time, I also brought the monitor back. And I got a different one. Not my monitor but a new / different device of the same type. So right now, it is working again.

Conclusion:
If your Samsung / Samtron (same brand, different name) shows a message, saying: “not optimum mode recommended mode…”, please bring it back to your agent as soon as possible, and problem will be resolve just by new / different hardware.

There is a possibility to run a macro, each time the workbook is opened. This macro could be used to apply certain functionalities or formats on the workbook. How to do this?

Here you go:

1. Close all workbooks and start a new Excel-session
2. Start the VBA-Editor: Tools –> Macro –> Visual Basic
3. Go to the Project Explorer window (Ctrl+r)
4. Double-click on the ThisWorkbook object.
5. In the drop-down menu above, choose: Workbook (normally there is General written)
6. Automatically there will occur a private sub Workbook_open(). This is the method which is run each time this workbook is opened.
7. Insert your code there.

  MsgBox "The macro is run right now", vbOKOnly, "Startup-Macro"

After saving the workbook and starting it, you will see, that this macro is executed at start-up-time.

In Excel, you may experience the following problem: You have groups inside your worksheet. And you may want to protect your worksheet. The result is: your grouping is not usable anymore.

But, of course, there is a solution for this problem: VBA.

Create the following VBA-macro.

ActiveSheet.EnableOutlining = True
ActiveSheet.Protect DrawingObjects:=True, contents:=True, userInterfaceOnly:=True

After you run this macro, the group is still available, although the rest of the sheet is protected. But, this property is not saved. So, if you open the workbook again, you will experience, that the worksheets grouping is again not working. To solve this problem, you can insert a functionality as a method during the opening of the workbook. I will describe a solution for that later.

Mathematics is always nice and logical. But the formula I found on this axe-perfume is strange…

It means, you use Axe-shower-gel + Axe-perfume and the result might be:

a) You will get a woman
or
b) you will become a woman.

I am not sure. And so I will not use Axe anymore…