Microsoft Office Forums - View Single Post - Show Userform hide active document only

Thread: Show Userform hide active document only

View Single Post

Old

03-25-2020, 07:01 PM

Just Learning Just Learning is offline

Just Learning is offline

Just Learning uses Windows 10

Windows 10 Just Learning uses Office 2019

Just Learning uses Office 2019

Office 2019

Novice

The original poster

Join Date: Mar 2020

Posts: 7

Just Learning is on a distinguished road

Default

Hi Guessed,

Thanks for the suggestion.

Here are the details

- Private Sub Document_Open()
UserForm1.Show
End Sub
-Private Sub CancelButton_Click()
UserForm1.Hide
ActiveDocument.Close SaveChanges:=wdDoNotSaveChanges
End Sub

- The code is in the document only

Reply With Quote