macro save as

[max_max]

Hello to all.
in the attached workbook there is a macro to save to a folder by clicking on the "SALVA" button
There is a problem with the new saved workbook.
When I open this workbook the first time the ribbon toolbar is disabled, at the second time they are active.
If I click the Windows button, they are activated the first time.
To test the macro insert the workbook in a folder and insert a folder named "sheets" into it.
I hope I explained myself.
max_max
prova 19_05_18.xlsm

[Logit]

.
No issue here. Works as intended.

????

[max_max]

The new sheets that the macro Sub EsportaFoglio()
in workbook prova 19_05_18
they have the ribbon toolbar buttons they are inactive, they are blocked.
To activate them I have to click the window button on the keyboard
max_max

[Logit]

.
I understand. However, everything works as expected here on my computer. No problems ... all tool bars work first time .. nothing is grayed out or inactive. Everything is fine.

Whatever the issue, it has to involve something with your computer.

I am unable to re-create the issue you experience, here on my computer.

[max_max]

I take a baseball bat.....

[Logit]

[rlv]

It works for me as well (excel 2010). No problems seen. Do you have any sort of non standard add-in that modifies the ribbon?

[max_max]

Searching on the net I found:

Can't Click Excel Ribbon
https://social.technet.microsoft.com...on?forum=excel

and I found:

Recently had this.
Get the user to open the file from within of Excel. (Open Excel> File> Open> Navigate to your file) And the ribbon does not crash.
Either closing the underlying file listing (explorer window), or turning off preview altogether completely solves the problem.


I solved by deactivating the preview inside the folders.
max_max

[Logit]

.
Happy you found the solution !

Salute !