We've been using this workbook for years and I've never seen this before. I've checked the obvious things I could think of: Macros are enabled, the buttons are still linked to the macro code, and the sheets aren't protected. If you edit or add a macro action, Macro Recorder opens an action configuration window. I can select the macro itself from the macro menu and it runs just fine. If I select design mode, select the button, and select properties (in this copy of the workbook), I get only the properties for the sheet, not for the button. it just isn't possible to click on the buttons. This morning one user forwarded me his copy of the workbook and, in this particular workbook, it is not possible to click on any of the macro buttons. You can assign a macro that is recorded in IntelliPoint to a key or to a mouse button. They can also be used to replay sequences that are long or difficult to execute. The workbook has dozens of macro buttons on multiple sheets to do things like Add New Row to preserve formulas. Macros are sequences of events (such as keystrokes, mouse clicks, and delays) that can be recorded and later played back to help perform repetitive tasks. The zipped file is in xlsm format, and contains macros.I have an Excel workbook which is used as a template for dozens of Project Managers using various versions of Excel (2003, 2007, and 2010) to use to track project expenses. On the Sample Files page, go to the UserForms and VBA section, and look for UF0024 – Click Check Box to Run Macro To see all the code, and the To Do list with check boxes, you can download the sample file from my Contextures website. To test the results, click on any one of the check boxes, and the Date cell in that row should change. You won’t see a change on the worksheet, but now each check box has the macro assigned to it. To assign the CheckBoxDate macro to each check box, run the SetCheckBoxesMacro macro. In the macro, we’ll set the OnAction property to the date macro name Sub SetCheckBoxesMacro() Instead of manually assigning a macro to each check box, we’ll create a macro that’s similar to the one we used to link all the check boxes to a cell. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |