This is actually for a friend, I told him I would take a look at it, but I don't much about this. ' Set default position, and turn on Screen Update ' We only need to put the processed info in the right cells.Ĭells(RowNumber, 4).Value = Cells(7, 4).ValueĬells(RowNumber, 5).Value = Cells(7, 5).ValueĬells(RowNumber, 6).Value = Cells(7, 6).ValueĬells(RowNumber, 7).Value = Cells(7, 7).ValueĪctiveWorkbook.Names().Delete ' The information from the website has been processed in Excel. With Sheets(' Watch List').QueryTables.Add(Connection:=YahooURL, Destination:=Range(' O1')) YahooURL = Yahoo + TSymbol + '& f = nl1d1p' If StopCount > 100 Then GoTo LastLine ' Exit if more than 100 empty cells Loop ' The loop to retrieve the fund informationĭo While Range(' B' & RowNumber).Value = '' ' Set the screen update to False and get the # of funds ' It updates the watch list based on the most current fund pricesĭim YahooURL As String, Yahoo As String, TSymbol As String, NoFunds As Long, I As Long

So here is my code: Private Sub WatchButton_Click()

Recent ClippyPoint Milestones !Ĭongratulations and thank you to these contributors DateĪ community since MaDownload the official /r/Excel Add-in to convert Excel cells into a table that can be posted using reddit's markdown. Include a screenshot, use the tableit website, or use the ExcelToReddit converter (courtesy of u/tirlibibi17) to present your data. NOTE: For VBA, you can select code in your VBA window, press Tab, then copy and paste that into your post or comment. To keep Reddit from mangling your formulas and other code, display it using inline-code or put it in a code-block It will generate a usable code that will unlock your protected sheet.

The code used in this instruction is one of the simplest Ive found. This will award the user a ClippyPoint and change the post's flair to solved. VBA Code to Unlock a Locked Excel Sheet: If you have ever forgotten a password for one of your excel worksheets you know how frustrating that can be. OPs can (and should) reply to any solutions with: Solution Verified Only text posts are accepted you can have images in Text posts.Use the appropriate flair for non-questions.Post titles must be specific to your problem.

Excel vba on error next