Search results for query: *

I am trying to run a macro located in Workbook B from some VBA in Workbook A within Excel 2007 I've tested this code in some test workbooks and it works great. However, when I try this from the actual workbooks, it does not work. I get an error:Cannot run the macro 'name of macro' The macro may...

thanks for your help. The problem persists and I suspect it is likely user error 8). Thanks for your time and for the help.

Thanks, but I've exhausted all the normal resources. No one seems to be able to track down this problem. There is no property to set for rows displayed, strange, but true. When I reload the form, the box will show all the results, until the above-described situation results again. very strenge...

I've got a listbox that gets its values from a range on an associated worksheet. The range size varies on a search result. The problem is this: if the results returns, say, 5 items the first time it is run, the box will display the 5 items just fine. If the next result is more than 5 items, it...

What I am actually trying to do is change the Workbook Before Close event on all of these workbooks... crazy, I know... but there are a ton of them and changing them by hand is gonna be unfun.

Rofeu, You're a lifesaver. Thanks. I hate to ask another question, but... how would I go about putting the new code in the Workbook_Close event?

I know I read how to do this somewhere, but I can't remember where. Is there some way, I do remember it was through code, to change a VBA module in multiple workbooks. They are all in the same directory, if that helps. (Administrators have decided to add some functionality to spreadsheets after...

I'm trying to be able to generate a list of workbooks based on a range they contain called DateofChange. This is a simple date value. What I want to do is, from another workbook using VBA or VB proper in an independent program, to be able to "search" a number of workbooks and sort them based on...