X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Code Fires When Worksheet Activates - Not A "form" Issue, Office 2013    
post Dec 7 2017, 04:32 PM

Posts: 5,231
Joined: 2-November 04
From: Downey, CA

I am working with 2 workbooks, and one has two tabs (worksheets) - I want my code (which is just selecting a single cell range) to run when I activate the worksheet - If I have to hard-code it, that's great, because the tab names don't change - everything I found when I searched the 'net is for FORMS in Excel - I found this, and tweeked it, but no go...

Private Sub Worksheet_Activate()
End Sub
I tried replacing the combo box reference, but it didn't work - like I said, if I have to hard-code the reference to the particular workbook, that would be even better...

... any help would be greatly appreciated . . .
Go to the top of the page

Posts in this topic

Custom Search
RSSSearch   Top   Lo-Fi    19th October 2018 - 12:02 AM