Run Time Error: Item with specified name not found
So I'm using shapes in my database to pull information from the sheet into another. However when I click on a second shape over the information I want to pull I get the run time error stating that the specified name could not be found; when I click on a third shape it functions correctly until I click on a fourth shape and so on. 1st 3rd 5th etc good; 2nd 4th 6th etc run time error.
Any ideas as to what's going on?
Please Login or Register to view this content.
I'm assuming the error occurs on this line, but if it's a different line you need to tell us.
Are all the shapes set to "assign macro" to this sub? Have you checked the value of Application.Caller at the point where you get the error?Please Login or Register to view this content.
I'm not sure what's causing that error but you should dimension rn as Long instead of String.
Can you attach your file? The paper clip icon does not work for attachments. Instead, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.
Yes all the shapes are assigned this macro.
The line in question does pull the correct row number even when the error occurs. Additionally, when I remove the protection and un-protect
sequence from the script there is no error. The yellow lines in the file have the protection sequence while the clear lines do not.
I need the unprotect and re-protect sequences since non admin users will be accessing this database and I don't
want them to be able to make changes or access the code
Here is the file
Why do you run the unprotect/protect in a loop? BTW for this type of loop, the textbook method is a For loop.
This does not exist
Admin_Unprotect_Workbook
so I commented that line out to get your code to run.
The problem is that something in your code is activating Order_Builder before it gets to the line of code causing the error, so ActiveSheet is no longer Database. If you want the sheet reference to be Database, then use that instead of ActiveSheet. I counsel against using ActiveSheet in most situations and this is a classic example of why.
Please Login or Register to view this content.
Thank you very much 6StringJazzer! That was a huge help!!!
also I ran the unprotect/protect in a loop because excel kept skipping it in execution. Running it twice in a loop was the only way I could get excel to not skip it
The bit about the loop doesn't make any sense to me. I would have dug into it but I'll bet Admin_Unprotect_Workbook has something to do with it and you did not include that in the file you attached.
yes thats true. Its a script that runs to password protect and unprotect the sheets and workbook. Without the loop excel kept skipping it an either leaving the sheet unprotected or otherwise
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks