I cant any changes on excel file that opening by my userform

[nekooee]

Hi my dear's
Why when I opening any excel file by my userform I cant any change on it.even print or change the cells data
Please helpe me.I cant speak English currectly

[jaslake]

Hi nekooee

Change your Code for opening the Form to

UserForm1.Show vbModeless

[jaslake]

You're welcome...glad I could help.

If this resolves your issue please mark your Thread as SOLVED.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[nekooee]

Thank you for your answer
with your answer solved my problem about change data, but when I open the form by this code After the Excel file is opened by my userform and when close the excel file userForm closes too.i use this code in workbook_activate "mainuserform.show vbmodeless" but i want when activate my excel file my userForm Equally ago display.(for example i use the multipage on form and i want open the page 3)sooth when open main excel file opens page 1 of multipage or if is possible not close my userform.
thanks and best regards

[jaslake]

Hi Hi nekooee

If I understand your issue, place the Code in the ThisWorkbook Module

Option Explicit

Private Sub Workbook_Open()
   mainuserform.Show vbModeless
End Sub