I open a workbook using vba below operated from a userform
Sometimes I can't type into the cells in the new workbook unless I swap between the workbooks and don't have undo until I do the same. If I open it and I can type into the cell I still don't have undo unless I swap between the workbooks.
not sure if its activating the workbook to run the cmd or .... I had the issue when i didnt have "unload me" and once adding that then allowed me to type most of the time but sometimes it doesnt and I still have the undo problem.
Sometimes I can't type into the cells in the new workbook unless I swap between the workbooks and don't have undo until I do the same. If I open it and I can type into the cell I still don't have undo unless I swap between the workbooks.
not sure if its activating the workbook to run the cmd or .... I had the issue when i didnt have "unload me" and once adding that then allowed me to type most of the time but sometimes it doesnt and I still have the undo problem.
VBA Code:
Private Sub NotesLabel_Click()
ThisWorkbook.Activate
Range("notes").Select
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
ActiveWorkbook.Sheets("Notes").Select
Unload Me
End Sub
