You can get around this problem by saving your macro workbook seperately as an excel add in. You then need to assign each toolbar item to the desired macro.
NOTE:
The macros stored in your excel add in are not displayed when you try to view macros in 'all open workbooks'. You can select it by...
I'd like to open an access form in its own window either by hyperlink or by vba from an excel spreadsheet. It is important not to overcomplicate the database manipulation because the users are afraid of databases.(Techno fear in abundance!) Any ideas?
I have a large, shared worksheet and require different views of the system for various users. I need to create a macro to open a dialogue box requesting this password which after successful entry the user clicks ok and a worksheet is displayed. I'm using a separate worksheet at the moment to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.