Hello All,
I use the macro below to go back to the last active sheet and it works.
Public LastWorksheet As String
Sub PreviousSheet()
If LastWorksheet <> "" Then
Worksheets(LastWorksheet).Activate
Else
MsgBox "No other Sheet has been selected."
End If
End Sub
I also want to hide the active sheet before turning back to the last active sheet and add something like this to the above code but somehow it doesnt work.
ActiveSheet.Visible = False
Any help would be much appreciated!
Bookmarks