Gandalf
Member
Hi, me again
I have a bit of code that opens a userform when the workbook opens. This works fine on the PC that it was written on but when I open it on my laptop (Panasonic Toughbook cf-19) it fails to open. Both machines are running the latest Office 365, Windows 11 pro and it is a trusted document on both. All other vba works just not the userform1. The code below is in Workbook
>>> use code - tags <<<
Any help would be appreciated, many thanks.
I have a bit of code that opens a userform when the workbook opens. This works fine on the PC that it was written on but when I open it on my laptop (Panasonic Toughbook cf-19) it fails to open. Both machines are running the latest Office 365, Windows 11 pro and it is a trusted document on both. All other vba works just not the userform1. The code below is in Workbook
>>> use code - tags <<<
Code:
Private Sub Workbook_Open()
'Step 1: Select the specified sheet
Sheets("Instructions").Select
Range("A1").Select
' Show userform when workbook opens
Call UserForm1.Show
With UserForm1
.Top = Application.Top + 320 '< change to what you want
.Left = Application.Left + 850 '< change to what you want
End With
End Sub
Any help would be appreciated, many thanks.
Last edited by a moderator: