Before_Close VBA function

[akparasite]

Does anyone know of a slick way to make a worksheet reset the active cell to a particular worksheet/cell reference upon closing?

Why? I have some macros that require that the first sheet in the workbook is the active cell, and I don't want other users to mess up the file by saving it without resetting to the first worksheet.

Your help is greatly appreciated!

 

[JohnG]

Try this

Private Sub Workbook_BeforeClose(Cancel As Boolean)
On Error GoTo NOMENU
Range("A1").select
Exit Sub
NOMENU:
On Error GoTo 0
End Sub

 

[KniteMare]

It only has to APPEAR to happen on close. Instead set this to happen on OPEN like this:

In the WorkBook Module place this snippit

Private Sub Workbook_Open()
Sheets("Sheet1").Select
Range("A1").Select
End Sub

Done like this it does not matter if they save changes, each time the work book opens it goes to sheet 1 cell A1

If you switch between workbooks put this in the WorkBook Activate event as well Like this:

Private Sub Workbook_Activate()
Sheets("Sheet1").Select
Range("A1").Select
End Sub


Yours in EXCELent Frustration

KniteMare

 

[akparasite]

Excellent...I'm getting better at this VBA stuff now...I appreciate the help!