-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Display a message Box when Opening a Workbook
- Thread starter Foxfire
- Start date
Big Monkey
Active Member
- Joined
- Nov 5, 2005
- Messages
- 255
In the ThisWorkbook module:
Code:
Private Sub Workbook_Open()
MsgBox ("Refresh Balance Sheet before continuing")
End Sub
Upvote
0
crosseyedanddrueling
Board Regular
- Joined
- Feb 8, 2007
- Messages
- 178
Monkey...were is the "this workbook" module at and how to you acess it?
Does every newly created workbook have a this workbook module already or does it have to be created?
I was trying get this to work by pasting your code into a module created within a new workbook....Im a newbiee to stuff im sure Im missing something silly...thanks
Does every newly created workbook have a this workbook module already or does it have to be created?
I was trying get this to work by pasting your code into a module created within a new workbook....Im a newbiee to stuff im sure Im missing something silly...thanks
Upvote
0
