Excel Macros: Unable to Activate, Stuck in Design Mode (Developer Tab)

Hello!
I can't turn on macros!
Of course, I'm trying to do what I can and turn them off in all possible ways.
(for me it works on everyone else, it doesn't)
and it is still highlighted DESIGN MODE in DEVELOPER>
I don't know what's going on here.
HELP
I admit!

I think there is something about it here https://www.elektroda.pl/rtvforum/topic1253193.html

I think the problem is a bit more complex because, I found out that the EXCEL file grabbed some source file and thus after copying it doesn't work on another kmp.
What can you do with it and how?
Does anyone know?
PZDR!

Quote:

I figured out that the EXCEL file caught some source file

I don't know what the author meant in writing the above. However, I have a little fear so I'll ask. When designing macros, did you use additional objects that are not installed as standard and are not available on other computers?

I suppose not (although it is possible) because these are business computers, so they are standardized.
And what could it be, for example?
When I write "source file" I mean that clicking on EXCEL "links" will insert a file on the C \ Documents and Settings drive ... a certain file as a source.
However, other computers demand the same.
Best of all, VBA works and recorded macros do not.
Do you know what is going on here?

Wait a minute. At will and systematically.
Links to other files are one thing and a non-running macro is the other. The first (link) is created when in the file, let's call it the main one, you use data from another file. Normal symptom to avoid duplicating data unnecessarily. On your computer, the main file can open without any additional message because you have the file with additional data and Excel knows where to find it. However, it is enough to send the main file to another computer or change the location of the data file and at 100% when opening the main file you will receive a message that "The opened file contains links ..." If you do not want to update the external data used, no problem.
Now VBA.
You write that:

Quote:

Best of all, VBA works and recorded macros do not.

1. How did you check that it works?
2. Upload the code of the broken macro. (I'm far from Copperfield)
3. Does the macro try to start and stop at some point (what?), Or does it not start at all?
4. At what level do you have macro security set?

1. How did you check that it works?
odp1) I click on the "button" and the VBA assigned to it works, ie it does what is written in the command lines, adding data to other sheets, MsgBox. The same thing that is recorded as macros, i.e. the recorder of my steps does not work. I mean, I click on the previously operating macro (on my computer) and nothing has any effect

2. Upload the code of the broken macro. (I'm far from Copperfield)
Answer2) I will be able to put the code only tomorrow in the evening. And maybe something more

3. Does the macro try to start and stop at some point (what?), Or does it not start at all?
Reply3) as I wrote in point 1, it does not start at all.

4. At what level do you have macro security set?
res4) On the lowest. I have tried every configuration.

And as for the source file I wrote about, you are probably right.

Quote:

it does not start at all

We are slowly getting closer to the goal.
1. How is it run.
2. Have you tried to run them directly from VBA (via F5 for example)?

1. How is it run.
re1) (I don't know very well what you are thinking) By pressing the "created button"

2. Have you tried to run them directly from VBA (via F5 for example)?
Answer2) I didn't try it because I don't know the method. I will add that there are about 50 of these macros recorded, will this one F5 button heal this situation?
Well, let it work.

F5 is not for healing.
It is used to run a specific macro directly in the VBA editor.
Your is started by a button. Put the sheet in design mode and check that it is properly assigned to the button. By the way. What button is this (forms or Control Toolbox)? Because the button is not the same as the button.

Approx. I will check it as I wrote tomorrow evening.
And the button is created from the toolbox i.e. insert etc.

Added after 2 [minutes]:

Is there a way to check if it's the button's fault?

Added after 2 [minutes]:

And one more thing that may turn out to be important I did not mention;
On another computer, assigned macros count from 0 as if they were not there, and when entering macros, there are commands, etc.
So it is very possible that it is to blame for the button ???

Quote:

On another computer, assigned macros count from 0 as if they were not there, and when entering macros, there are commands, etc.

No, it's already overwhelmed me. Who is counting, what is counting, how is counting? An example please. I mentioned that Copprefield was neither of me. I work in a binary system.

Hehe OK.!
An example tomorrow evening.
I will have to "remove" or "change" some things because it's business matters and sometimes some ACTA will catch me or something and there will be unnecessary problems.
However, I will insert everything I have and how and what it is about.

Added after 1 [minutes]:

However, from this exchange of information, I perceive that;
closer to you to Copprefield than me to you
Regards!

Hello! As promised, I am adding an attachment.
(I couldn't before)
I don't know what's going on here and why these macros don't work anymore.

Maybe when you see what the idea of this game is like, you can give me some more ideas for solutions.

I came, I looked, I doubted.
I look again and see nothing. I look. I don't have an eye.
How do you write down the next hundred macros in a file whose name sounds proudly PERSONAL.XLSB then watch them for yourself.
I cannot telepathically. I repeat again. I'm not Copperfield.
And for the future, if you want all your macros so carefully saved to work after transferring the file to another computer, just save them in this file, not in Personal. Create modules and push macros there. Or, move Personala together with the workbook. The choice is yours.

Edit:
One more suggestion. I'm a conservative and I'm barking at any Ex-le above the 2003 version. So if you want me to watch and play with your file, save it in the old format. This has another advantage. No need to pack. Elka is also a conservative.

So what should I do?

Added after 1 [hours] 54 [minutes]:

Save it to another file and then it will work?

Move or copy from Personal the macros used by the workbook in question to the module created in it. Then they will also work after transferring the file to another computer.

However, I understand that I will only do it in the file where I saved it all?

I will say otherwise
The file on other computers does not work for you because all the macros in this workbook refer to the PERSONAL.XLSB file. which is on the source computer.
To make it work with this workbook, move / copy PERSONAL.XLSB to another computer (to the XLstart directory) or [and this is a better solution in my opinion]
open the main file on the "source" site. Enter the VBA editor and copy the macros from PERSONAL.XLSB to any module in your file.
However, it will be necessary to correct the references under the buttons to the appropriate macros.


But why did they sign up there (in PERSONAL.XLSB)? Until the end, I do not know all the "games" of excel 2007 and higher, but I already had something similar somewhere.

I will be able to try to do it tomorrow at the earliest.
But thanks so much !!!

marek003 wrote:

But why did they sign up there (in PERSONAL.XLSB)? Until the end, I do not know all the "games" of excel 2007 and higher, but I already had something similar somewhere.

I already know (it's not a version issue - but I've never used it so this ignorance)
The case concerns "saving recorded macros and the option of where to store the macro.
You probably have "Personal Macro Workbook selected."



And then the macros are just saved to personal.XLSB (This kind of secures Excel against the "horror" of macros)
There are advantages and disadvantages of such a solution (I prefer to save macros in the workbook in the old way, and if macros are to be available for other workbooks, this is what the xla (xlam) "extension" is for.

Because this is how you have to move the personal.xlsb file together with a given workbook, but this file can contain "thousands" of previous macros (recorded for other workbooks) so why transfer it all to another computer - there may also be a different one there ( with other macros) the same file.
As for me, a bit of a sick solution ... but everyone has their own style of work.

Copy the macros in the VBA editor from presonal to the module in the main workbook and it will be ok.

Okay!
I will certainly check this solution or solutions
Only that, unfortunately, as I wrote only tomorrow.

(and this ignorance ... it's not terrible, we all learn, exchange statements, etc.)

Greets everyone after a long break!
However, it was only today that I returned to action
I try to try and try iiiiiiii nothing.
Maybe I'm making some stupid mistake.

Could you please explain the topic of this copying how from from to to.
Just like a cow in a ditch .......
GREETINGS and THANKS IN advance !!!!

Open the file on the computer it is running on.

When it opens press Alt + F11
If you don't see the project explorer window on the right side, press Ctrl + R

Find there VBAproject (personal.xlsb)
Press the plus next to it (the project will unfold)
Open the "modules" folder
"grab with the mouse" the module with your macros and drag it onto your file project [ VBAproject (your_file.xls) ] (no matter where - to within your project.
A given module will be created (copied) in your file.
Your macros can be in several modules, but they can also be in one - I have no idea how you are organized when I can't see it.

When you're done, Alt + F11 again

And now longer work because you have to reassign macros to buttons (only those macros from your file, not from personal.
When you finish this
saving the file
and that's it.

THANKS!!!
Buddy, you are GREAT !!!
Now everything works and works well !!!
(and you can say "how easy it is" ) and ignorance and lack of awareness of certain matters almost finished me
Well, but there are some who can !!!
CONGRATULATIONS

however, I noticed that this project already poses new challenges and perhaps even more difficult
I will fight nothing ...
Thank you again for your help and commitment !!!