Cells(emptyRow, 10).Value = saljare.Value Cells(emptyRow, 9).Value = bestallare.Value Cells(emptyRow, 8).Value = planstatus.Value Cells(emptyRow, 7).Value = markyta.Value Cells(emptyRow, 6).Value = byggratt.Value Cells(emptyRow, 5).Value = loaboabta.Value Cells(emptyRow, 3).Value = gatuadress.Value Cells(emptyRow, 2).Value = projekttyp.Value Cells(emptyRow, 1).Value = fastighetsbeteckning.Value Sheets("grundmall").Copy Before:=Sheets(2)ĪctiveSheet.Name = fastighetsbeteckning.ValueĮmptyRow = WorksheetFunction.CountA(.Range("A:A")) + 1 'copy sheet named "grundmall" and give it the name provided in fastighetsbeteckning
I'm using Office 2013 and my friend is currently on a Mac with Office for Mac 2008.
I'll add the code here and if there's anyone out there with a good answer please let me know how to make this work on a Mac. It works brilliant on my PC, but on my friends Mac it doesn't work at all. I have created an Excel-workbook with a VBA form in it for saving information in a new sheet every time you use the form. Some people/pages say that it just "should" work, other point me to the Ron de Bruin webpage but I don't understand Microsoft does not guarantee the accuracy of this third-party contact information.Before I post the problem I want to clarify that I've been googling this for while now and can't seem to find to right way to solve it. This contact information may change without notice. Microsoft provides third-party contact information to help you find technical support. Microsoft makes no warranty, implied or otherwise, about the performance or reliability of these products. The third-party products that this article discusses are manufactured by companies that are independent of Microsoft.
Troubleshoot Office 2011 for Mac issues by completely uninstalling before you reinstall Method 4įor information about how to remove and then reinstall Office, see the following article: If you do not want to keep your existing account, you can rename the "Test" account that you create in the following procedure, and continue to use that account. If you can save when you use a new user account, contact Apple support to troubleshoot your existing account. Open Excel and check if the issue is resolved. (If this option is not available, just go to the next step).Ĭlick the Apple icon, and then click Log Out name. When you receive a warning, click OK.Ĭlick to select Allow User to Administer this computer.
Type the word Test for the user name, and leave the password box blank. Log on by using your Administrator user name and password, and then click OK. If you are not the Administrator of the computer, click Click the lock to make changes. Click Force Quit to quit the application. Select the application in the "Force Quit Application" window, and then select Force Quit. If you cannot quit an application or do not know how, hold down the Command and Option keys, and then press Esc on your keyboard. To quit an application, select the application on the toolbar (top), and then select Quit. You must quit all programs before you continue. To resolve this issue, try the following methods, in order, until the issue is resolved.