How to tie Userform to only 1 workbook

ijhoeq

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?
 

Logit

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

Top