How to place the Call subroutine into a spreadsheet?
- Thread starter Eloise T
- Start date
Eloise T
Active Member
I should simply say, "Thank you," but since I know a miniscule amount of Spanish, I'll translate your answer with your approval...
Copy the code
Type Alt + F11
Double Click to ThisWorkbook
Paste the code
and Ready!
Close VBA.
...and ???? use.
But, I'm still not seeing this:
I am seeing this after typing ALT + F11 and none of the icons (especially in the upper left) drop down with a menu that look like your picture.
They do look like:
...and this:
Suggestions? By the way, I'm using Excel 2016...if that matters.
Copy the code
Type Alt + F11
Double Click to ThisWorkbook
Paste the code
and Ready!
Close VBA.
...and ???? use.
But, I'm still not seeing this:
I am seeing this after typing ALT + F11 and none of the icons (especially in the upper left) drop down with a menu that look like your picture.
They do look like:
...and this:
Suggestions? By the way, I'm using Excel 2016...if that matters.
Eloise T
Active Member
OK, so it type ALT + F11, then F2 then F4 and get:
Where do I paste:
Code:
Private Sub Workbook_Open()
Call StartFlashing
End Sub
Eloise T
Active Member
THANK YOU!
Debaser
Well-Known Member
In the good old days of Excel 2003 and earlier, you could right-click the workbook window icon and choose View Code to go straight to the ThisWorkbook module (much like right-clicking a sheet tab to get to its code module). There doesn't seem to be any equivalent in the later versions sadly.
Eloise T
Active Member
Nice to know. Thanks.