Then the ActiveX part explains why your worked and my didn't.
Well, made me a ribbon insted of the commandbar and now that works too. So problem solved I guess.
Tanks you all.
Now, why it did not work from the start, that I don't understand.
None...
Perhaps you used an activex button instead of a button... Did you? cuz when I try an activex button it works. (Had not thought about that before)
Solves a few of my problems. But most of my functions is on a commandbar(produce the same error as a button) that don't work - guess I have...
Yes, that's the drive on the network - my home network, but I get the same problem on the servers at the network at work.
Everybody that shall use the file has access to the drive. Write/Read/Exe.
Separately the Excel or Word file, with macros, runs fine over the network. But now I have en embedded excel in a word file.
Well, the macro never runs if I click a button - so that's not the problem. If I open the Macro dialog and choose a macro and press run it works.
So you are saying...
It's a big application, but the problem occurs even if you do a simple setup.
Create an Excel file
Create a Word file
Embed the excel file as an icon in the word document:
One Form button in the excelfile connected to a macro with this code:
Sub Knapp1_Klicka()
ActiveCell.FormulaR1C1 =...
I have a Embedded Excel in a word file. Excel is embedded as an icon. Office 2007.
As long as I save the file on my harddrive, it works fine, but If I save it on my server or NAS then it don’t' work.
In my excel file I have a macro connected to a button. (It’s a lot of macros and menus and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.