PDA

View Full Version : Solved: Do something only at opening of workbook



Rejje
05-27-2011, 02:21 AM
Hi!

I'd like to make my project run som thing everytime the workbook opens, but only then.

For instance: I would like for the workbook to open in a specific worksheet (called "KP") with columns and rows scrolled to A:1. This is regardless of what worksheet was active when I last saved and closed the project.

How does it look like?

ntrauger
05-27-2011, 05:18 AM
Private Sub Workbook_Open()
Sheets("KP").Activate
Range("A1").Select
End Sub

Rejje
05-27-2011, 09:20 AM
Perfect! Thanks!