This macro runs upon opening of my book.
This Macro is supposed to allow all sheets in the work book to run ALL MACROS while in protected mode, then ask if I want to open up two other books.
When it runs it continually loops.
Can someone help me troubeshoot. I am not certain what is wrong.
Here is the code.
Any help would be appreciated
Please Login or Register to view this content.
You've got:
in the loop of every worksheet. So you're opening a worksheet and doing this for every single worksheet.Please Login or Register to view this content.
Hi,
Just a little advice
Please Login or Register to view this content.
Don't hard code paths in your code, use variables or a dialog to select the file, this avoid you needing to modify your code if another file is required.
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
That was the trick thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks