Since update I can no longer have the workbook protected and refresh connections. Any one can use this microsoft program easily and can manage their work correctly. Apr 26, 2009 I have a simple function below to put in different forumlas in different cells to get stock quotes. You could get rid of the error if you keep cancelling it, but the report doesn't get updated with latest reports. Nov 1, 2008 I have a worksheet where there are a few columns.
Unprotect The macro is executed by clicking on a button on the worksheet. They are not new employees. Thank you David very much for the macro, it works again! I need to have the tab sheet named Log protected how do I accomplish this and still be able to run the code?. I keep getting the above referenced error. In order to protect the users from themselves I protected certain cells. The columns involved in my problem is Column A and B.
Update My original work book is an Excel 2003. The only problem i have is if the incorrect password is entered when trying to unprotect the worksheet. I've tried what seems intuitive, but nothing works. Unfortunately, I've come across this again and cannot get around it. End With If I understand the question correctly, you will be the one protecting the sheet. Can you please provide step-by-step instructions for us to repro the problem locally? So, how can I modify the code below to work ie have the code modify the unlocked cell's validation when the sheet is protected without the above run-time error? Of course I do have to update all the workbooks that I have deployed! Hope you have now got the solution from facing this Runtime Error 1004. Hi Brian, Sure, happy to.
Don't get this when I run the same macro in 2000. Now you will be able to do compulsory modification to that page. I'm sure if it is possible, someone here would definitely know! I seem to have one version that works on older versions e. The original code was looping through all files in the 'MyPath' folder. So if I protect the vba project and unprotect the sheet tab log this means that users can change the data in the tab log and I was hoping that could not be done I need to record every entry that is made to that workbook. I am looking for the code to select the visible data after applying a data filter.
I I trying to simply fill a combobox on a userform from a named range on a sheet, I want to populate the combobox as soon as the userform starts. I am assuming I have superfluous code in there, in addition to my mistake with the reapplication of the password. But it still does not allow the use of the advanced filter when the sheet protection is on. I am trying to autofill from the selected cell in Column C down. I did finally receive an update to the ticket I logged through O365, although the information directly contradicts what Guy has said in this thread! What I am looking for is this.
Import back into Xcelsius It's crazy, but it has worked consistently for the last couple weeks for me here. You will get the error 1004 if the file doesn't exist. The sheet I imported has a sheet number of 77 while the previous last sheet was 23, could this be a cause? I do not know where the bold portion is coming from or why. May 27, 2008 Is there any way I can protect my sheets properly. I've looked through several other posts on this site as well as other options but have yet to find a solution.
One more question is there away of protecting you vba code? I've saved the workbook and even saved it as another name. The sheet works fine, but as many people will use this programme, I need to protect the sheets against mistaken entries etc. I am stumped on this one, however. My workaround is to use the BeforeRefresh event to unlock the workbook, and the AfterRefresh event to lock it again. The input filename and open the input file looks ok. Using the same workbook in version 1802 allows the data to be refreshed with the workbook protection left on.
It may work for you, it may not. You will be prompted for a password. It has been working fine for few months now. What I might be doing wrong? I have this same issue, the only work around I've come up with so far is to use a macro to run when the workbook is opened, unprotect the workbook, refresh the data not in the background and then lock the workbook. The underlined portion is what is higlighted with error 1004: Application-defined ro object-defined error. The last update is a real pain in the arse.
Unprotect The macro is executed by clicking on a button on the worksheet. The files that are being opened are the same as well - so I know they work in the original location and i've tested multiple versions of the file that's failing. You may share your valuable feedback for this on the below support links - Should you have any additional queries, please let me know. Probably no more than 150-170 characters in the line. For example, a user opens the workbook, he makes changes in the data, takes the outputs and uses it somewhere else.