littlepete
Well-known Member
- Joined
- Mar 26, 2015
- Messages
- 503
- Office Version
- 365
- Platform
- Windows
VBA Code:
Sub volledigscherm() ' - control L - [f11]
Set dezecel = ActiveCell
If Not Application.DisplayFullScreen Then
Application.DisplayFullScreen = True
Else
Application.DisplayFullScreen = False
End If
If ActiveCell.Row < 5 Then
Range("a5").Select
Else
dezecel.Select
End If
End Sub
hello all
I use an adjusted full screen switch on/off with a function key F11 ...
It works perfectly ! it records the active cell, then switches to full or not full screen, and then selects the last active cell again !
so far, so good, but:
i am adding cell activation to start macro's with a click on a cell in row three... that way clicking on cell E3 should start the full screen macro.
but, because the last active cell is effectively that cell E3 the full screen macro keeps repeating itself...
is there a way to stop that, or just do the macro once each time?
have a nice weekend all !!!