nasomi
01-07-2016, 07:20 AM
I'm working in excel 2013 and a few weeks ago wrote a bunch of scripts for a new workbook. It has buttons for filters and to flip between pages, onDoubleClick for sorting, etc. Working wonderfully, looks great, and very fast.
Yesterday I opened the template and went to click the button to load in some new data. It came up with "Can't find project or library". After a bit of messing around, I finally found that if I simply hit alt+F11 to open the vba editor, all macro's and buttons work. Since the underlying navigation relies on scripts, this is quite inconvenient. I've tried it on multiple computers and get the same result. Macro security is off, everything is trusted, and I'm still getting this issue.
Please tell me someone has encountered this and found a way around it.
Yesterday I opened the template and went to click the button to load in some new data. It came up with "Can't find project or library". After a bit of messing around, I finally found that if I simply hit alt+F11 to open the vba editor, all macro's and buttons work. Since the underlying navigation relies on scripts, this is quite inconvenient. I've tried it on multiple computers and get the same result. Macro security is off, everything is trusted, and I'm still getting this issue.
Please tell me someone has encountered this and found a way around it.