HELP! Missing order buttons
Solved
mod77
Posted messages
1320
Registration date
Status
Member
Last intervention
-
Mike-31 Posted messages 18405 Registration date Status Contributor Last intervention -
Mike-31 Posted messages 18405 Registration date Status Contributor Last intervention -
Hello,
Last night I worked on my excel file, I saved it. And this morning when I opened my file, all my command buttons are no longer displayed. I looked in the vba editor and all the command programs for the buttons are there.
But the buttons are not.
I was working in excel 2016. And this morning when I opened it, I saw "compatibility mode" next to the file name but I don't know if it was there yesterday.
After saving it in excel, I also saved it yesterday in libre office calc to see if it works.
Can someone help me get my command buttons back please? It's really important everything I did yesterday please,
Thank you
Configuration: Windows 8.1
Libre office
--
Knowing how to say NO is a duty and a strength! Don't be afraid! Unity is strength!
Please mark as resolved if it is!
Last night I worked on my excel file, I saved it. And this morning when I opened my file, all my command buttons are no longer displayed. I looked in the vba editor and all the command programs for the buttons are there.
But the buttons are not.
I was working in excel 2016. And this morning when I opened it, I saw "compatibility mode" next to the file name but I don't know if it was there yesterday.
After saving it in excel, I also saved it yesterday in libre office calc to see if it works.
Can someone help me get my command buttons back please? It's really important everything I did yesterday please,
Thank you
Configuration: Windows 8.1
Libre office
--
Knowing how to say NO is a duty and a strength! Don't be afraid! Unity is strength!
Please mark as resolved if it is!
8 answers
Re,
ah it's different if even the scrolls are hidden
open your file
then File/Options/Advanced Options/in the right list look for the section Show options for this workbook and under
For objects, Show:
check all
A+
Mike-31
I am responsible for what I say, not for what you understand...
ah it's different if even the scrolls are hidden
open your file
then File/Options/Advanced Options/in the right list look for the section Show options for this workbook and under
For objects, Show:
check all
A+
Mike-31
I am responsible for what I say, not for what you understand...
mod77
Posted messages
1320
Registration date
Status
Member
Last intervention
53
That's it already. I unchecked it and checked it again anyway. :-(
Hello
If I understand correctly, you must have hidden the ribbon.
In the top right corner, there is a small square icon with an upward arrow. Check it to restore the tabs and/or commands.
--
Argitxu
If I understand correctly, you must have hidden the ribbon.
In the top right corner, there is a small square icon with an upward arrow. Check it to restore the tabs and/or commands.
--
Argitxu
Hello,
you note in the visual the name of your buttons then temporarily on your spreadsheet you create a temporary button for example this button would be the
CommandButton25
then in the code you copy the name of the button to display to see if it’s what you are looking for
Private Sub CommandButton25_Click()
CommandButton1.Visible = True
End Sub
then if this is the solution, depending on the number of buttons to display you can create a loop
but you would have to check in your codes if you haven’t created a line to either hide or delete your Shapes
--
A+
Mike-31
I am responsible for what I say, not for what you understand...
you note in the visual the name of your buttons then temporarily on your spreadsheet you create a temporary button for example this button would be the
CommandButton25
then in the code you copy the name of the button to display to see if it’s what you are looking for
Private Sub CommandButton25_Click()
CommandButton1.Visible = True
End Sub
then if this is the solution, depending on the number of buttons to display you can create a loop
but you would have to check in your codes if you haven’t created a line to either hide or delete your Shapes
--
A+
Mike-31
I am responsible for what I say, not for what you understand...
Re,
yes, I understood that, then you say that in the Visual you see the property of your buttons, so you take my previous post and you apply my code for a button to see if it is simply hidden or if it does not display to see if it has been deleted
--
A+
Mike-31
I am responsible for what I say, not for what you understand...
yes, I understood that, then you say that in the Visual you see the property of your buttons, so you take my previous post and you apply my code for a button to see if it is simply hidden or if it does not display to see if it has been deleted
--
A+
Mike-31
I am responsible for what I say, not for what you understand...
Re,
I can no longer see, you can try to recreate another button on your sheet and be attentive to its creation number, if Excel creates a button with a number that appears in the VBA, it means that the buttons have been deleted.
--
See you,
Mike-31
I am responsible for what I say, not for what you understand...
I can no longer see, you can try to recreate another button on your sheet and be attentive to its creation number, if Excel creates a button with a number that appears in the VBA, it means that the buttons have been deleted.
--
See you,
Mike-31
I am responsible for what I say, not for what you understand...
RE,
to anonymize your file is very simple, first duplicate your file by saving it as
then put a Dupont or Duval in your first Name cell and increment it downwards.
There you go, it takes you 5 seconds at most, now it's up to you
--
A+
Mike-31
I am responsible for what I say, not for what you understand...
to anonymize your file is very simple, first duplicate your file by saving it as
then put a Dupont or Duval in your first Name cell and increment it downwards.
There you go, it takes you 5 seconds at most, now it's up to you
--
A+
Mike-31
I am responsible for what I say, not for what you understand...