PDA

View Full Version : macro save as



max_max
05-19-2018, 01:15 PM
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
22284

Logit
05-19-2018, 08:13 PM
.
No issue here. Works as intended.

????

max_max
05-19-2018, 11:19 PM
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
05-20-2018, 09:06 AM
.
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
05-20-2018, 10:08 AM
I take a baseball bat.....

Logit
05-20-2018, 10:20 AM
:rotlaugh:

rlv
05-20-2018, 11:46 AM
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
05-21-2018, 10:52 AM
Searching on the net I found:

Can't Click Excel Ribbon
https://social.technet.microsoft.com/Forums/lync/en-US/14496557-87c6-4f55-b780-177944653034/cant-click-excel-ribbon?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
05-21-2018, 11:31 AM
.
Happy you found the solution !

Salute !