#1
|
|||
|
|||
Macros have disappeared ?
Happy Christmas !
I wonder if anyone has any clues to this odd behavious in Excel 365, please ? My Excel installation seems to be fine - several complex Workbooks with many macros are working just fine. One, though, is not. Here are the symptoms . . . 1. Macros assigned to text-box buttons work as expected 2. Macros assigned to Worksheet code eg Private Sub Worksheet_Change(ByVal Target As Range) are not being triggered 3. When I go to the list of Macros using the button on the Developer tab, none are visible and all the options in the dialog which opens are greyed out. 4. When I open the VBA environment using ALT F11 and go to Tools . . . Macros . . . I get error Unexected error (35005). 5. However if I go to Project Explorer, the Macros are visible as usual in Module1 Grateful for any ideas where to start looking for the problem. Thanks Last edited by MartinGM; 12-26-2023 at 09:13 AM. |
#2
|
||||
|
||||
Have you allowed Macros in your set up. Go to File Account Options Trust Center Allow Macros
__________________
Alan עַם יִשְׂרָאֵל חַי |
#3
|
|||
|
|||
Good thought Alan, thank you. Sadly Macros are allowed
|
#4
|
|||
|
|||
I've recreated the Workbook. All's well.
The old one must have been corrupt - no idea how that happened ! |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
My post disappeared | zpy2 | Forum Support | 8 | 11-24-2023 06:13 PM |
Word has 'disappeared' from my PC | FredAstairesChair | Word | 6 | 10-20-2021 06:05 AM |
Disappeared list | DIMI | Excel Programming | 2 | 12-13-2019 07:00 AM |
Categories disappeared? | markg2 | Outlook | 1 | 08-02-2010 03:24 PM |
Look in box disappeared. Please help! | padbon | PowerPoint | 0 | 12-21-2009 02:09 PM |