This is probably a piece of cake for you, guys.
I have created 3 workbooks, each holding 1 macro hiding certain rows, and 1 macro that shows these rows again, since I don't want to print several
pages with just zeros in 5 columns. I have also added a new menu to the default menu, where the user then can either hide or show the rows. My custom menu opens and closes when the workbook opens or closes. Very neat!
Now to my problem. If I open two of these books, and then closes one of them, the custom menu also closes, although I still have one workbook open.
Can I avoid closing the custom menu as long as any of these workbooks are open?
Reply With Quote