ACharmedQuark
New Member
- Joined
- Mar 28, 2016
- Messages
- 1
I have a very simple Excel workbook that must be sent via email to hundreds of people. A requirement is this workbook must open to the "Home" sheet every time the user opens it. So, I used the ThisWorkbook Open method to accomplish this. It works fine locally, but when users download and open the workbook, they get a runtime error when the hit enable editing. The error occurs when I select the Home sheet. Below is the only code in the entire workbook, which is in ThisWorkbook open method.
Private Sub Workbook_Open()
Worksheets("Home").Select
End Sub
The error is object cannot be initialized when it hits Worksheets("Home").Select. If the user hits end on the runtime error, the worksheet will continue to open. However, management says this in unacceptable and must be resolved.
Any ideas?
Thanks!
Private Sub Workbook_Open()
Worksheets("Home").Select
End Sub
The error is object cannot be initialized when it hits Worksheets("Home").Select. If the user hits end on the runtime error, the worksheet will continue to open. However, management says this in unacceptable and must be resolved.
Any ideas?
Thanks!