rocka
rocka

Reputation: 15

Worksheet Calculate does not run from personal.xlsb

My Private Sub Worksheet_Calculate() runs when I place it into Sheet1(Sheet1) as a part of VBAProject (Book1) but it doesn't when I place it into Sheet1(Sheet1) as a part of VBAProject (PERSONAL.XLSB).

Why is that the case? What shall I do to make it run?

Thanks in advance!

Private Sub Worksheet_Calculate()
Dim LastRow As Long

LastRow = Cells(Rows.Count, 2).End(xlUp).Row

Cells(LastRow, 2).Offset(1, 0) = Cells(2, 1)

End Sub

Upvotes: 0

Views: 69

Answers (1)

Mark Fitzgerald
Mark Fitzgerald

Reputation: 3068

PERSONAL.XLSB is a hidden workbook that doesn't usually have formulas or anything else on its sheets. No formulas so nothing to calculate and the event never fires.

Upvotes: 1

Related Questions