Are there any ways around this so that it updates upon dragging the formula? People need to open the file to be able to sign up for various duty rosters. Products the last 3 columns will have a drop-down list which will be used to enter data into the cell. Both sheets have the same columns and everything. The odd thing is that everytime I try to click on one of the macros I get an error, but yet the macro still performs the function. Now when I open the workbook, the buttons don't work! It seems to get a small way through the macro but then stop with no error messages or any sign that it hasn't completed properly. Feedback Buttons provided by - Copyright © 2019 DragonByte Technologies Ltd. Another thing to check: was this file built using 32-bit Excel, and are you now trying to run it in 64-bit Excel? Hi folks, I am getting the above error when trying to create a new list from an excel work book.
I really appreciate anyone who can share any insight on this! We have also changed the anonymous access - in case this was an issue. Should be fine and in most cases it is, however there is one user who although they can open the file, can't seem to get the macro to run properly. If this is not then it would be fien to update every time the workbook is opened. ActiveX components require registration on each user's machine. The odd thing is if I create a new button it works fine until I save and close the file. I have read about sharing the file and I don't think that would make things any better.
One sheet is the user entry sheet called User Entry Screen. I used the 'Share Workbook' function under tools. Our staff can't read and they keep opening additional copies of the file! I have a large spreadsheet in Excel 2007. Anyway, I have 2 columns of data in an excel sheet and I wish to add this to a userform so that the userform displays the 2 columns beside each other with headings, like a table. I don't mean a save.
I have exported the list from a SharePoint 2007 site and can view it in Excel 2013, however trying to import it into SharePoint 2010 gives the error message: Could not load an object because it is not available on this machine. Regards Andy Hi AndyW2007, Have you tried to import the spreadsheet with a new workbook in excel 2010? Hello, I need to know how to auto-fill text based on text in another cell. Instead, the values are equal to the cell above the first entry formula value. I would also like the user to select a row on the table and then be able to bring up another table depending on the row selected. Now, I need to share this macro with some other people, so basically I've just sent that excel file on to the people that need to use it. The machines are obviously not exact copies.
Also, is there a way to pull out of Excel what is the current User's 'Options General Default File Location' entry? I have tried kb833714 but this is not applicable in my case. Then I saved and closed the workbook and went to lunch. Hi, I have tested using different versions of office from different machines and get the same issue. You'd first need to determine which of the objects are not being loaded up. If i disable all those add-ons i mentioned, Excel starts up without any errors, however i need these add-ins to work.
Everything works great, and I don't receive any errors. Once the user selects the cell shown in the example sheet, it should then bring up the user form. Data entry form I want to do the following: 1. How can I set up a list like this? To start viewing messages, select the forum that you want to visit from the selection below. Any way to find out which. If I right-click the button in Design Mode and select Properties, I get sheet properties not the button properties.
There will be an undetermined number of individual worksheets to accomodate new staff. At the end of the setup, it told me that the macros would not work properly. This is not causing me any visible errors once i click 'ok', other than i can no longer use the shortcut button to convert to pdf using nitro pdf. The user should then be able to select a particular row and insert it into the specified cell. Does anyone know how to fix this and get this error message to go away? Personally I think this is a really tricky challenge and any help with doing this would be extremely appreciated.
Home Cases Articles Do You Want to Track Your Cases, Monitor Status or Maintain Records About Cases? How can I prevent this message from popping up? Its really doing my head in. Is it possible to share a workbook with macros and have the macros work properly. Alanda I have searched and read all the help files. Hello, i've got the following problem: I want users to double-click on a row on a protected sheet and then do some code based on the row-number of the clicked cell. Click the Sign In link on the menu bar and click Register New User. Any help would be much appreciated.