wwbwb
Well-known Member
- Joined
- Oct 20, 2003
- Messages
- 513
Greetings all,
I am working on some production reporting workbooks. The users open their PRs and fill in their information. At the end of the day, a tech will open a Master PR which will import all the data for consolidation. Everything is working great.
The PR workbooks have code that runs at open. Basically security stuff to keep them from using toolbars and menus and such. When I use the Master PR to import the data, just copying a range from the PR to the Master PR, all the code runs for each PR that is opened. Here is my question.
Is it possible to prevent the PRs open code from running each time I open it from another workbook?
or will I have to add something to the PR code like: if master PR.xls is open exit sub
I am working on some production reporting workbooks. The users open their PRs and fill in their information. At the end of the day, a tech will open a Master PR which will import all the data for consolidation. Everything is working great.
The PR workbooks have code that runs at open. Basically security stuff to keep them from using toolbars and menus and such. When I use the Master PR to import the data, just copying a range from the PR to the Master PR, all the code runs for each PR that is opened. Here is my question.
Is it possible to prevent the PRs open code from running each time I open it from another workbook?
or will I have to add something to the PR code like: if master PR.xls is open exit sub