How to tie Userform to only 1 workbook


New Member
I've created a user form that uses multiple sheets in my workbook (workbook1). I want the user form to only access that specific workbook. But, when I open a different workbook (workbook2), the user form changes data in workbook2 instead of workbook1. It is changing data in whatever workbook is active. How do I make sure it only edits workbook1?


Well-known Member
Without seeing your code ... you could try changing anything that says "ActiveWorkbook" to "ThisWorkbook"

Some videos you may like

This Week's Hot Topics