Forum Discussion
Excel macro VBA issues
Hey guys.
- I wrote a macro, which contain other macros using Call orders. If I running the macros separately everything ok, from the main macro one of them didn't running it's like it skipped from the list. Reason unknown.
-On running I can see 4 application window get visible, and those didn't connect any kind of application. Also a Clipboard error message get visible, but I get a Clipboard cleaning macro, which several times cleaning the Clipboard, so it can't be. It's like a hack, or something which I don't recognize.
- One a sheets called Total, I can't use the built in group function and can't collapse the selected section so the project I working on lost functionality.
I didn't make any change on that side, but previously it was useable.
Thanks for help in advance.
Cheers.
Zsolt
2 Replies
See whether below can help:
1. Macro Skipping in Main Routine
If a macro runs fine standalone but gets skipped when called from another macro, check for:
• Missing Call keyword or incorrect syntax:Call MySubRoutine
• Error handling suppressing execution: If you're using On Error Resume Next, it might be silently skipping over errors. Try commenting it out temporarily or using:On Error GoTo ErrorHandler
• Exit points or conditional logic: Make sure there’s no Exit Sub or If block that prevents the call from executing.
2. Unexpected Application Windows & Clipboard Errors
Seeing phantom windows and clipboard errors could be due to:
• Shell or external calls in your macro (e.g., Shell, CreateObject, SendKeys)
• Clipboard contention: Even if you’re clearing it, another process might be interfering.
Try adding a delay before clipboard operations:Application.Wait (Now + TimeValue("0:00:01"))
Also, check for any Application.CutCopyMode = False or DoEvents that might be misbehaving.
3. Group Function Disabled on 'Total' Sheet
If grouping/collapsing stopped working:
• Check if outline symbols are hidden:
o Go to Data → Outline → Show Outline Symbols
• Ensure the sheet is not protected:
o Review → Unprotect Sheet
• Confirm that rows are grouped:
o Try manually grouping again (Data → Group)
• VBA might have disabled it:ActiveSheet.DisplayOutline = TrueThanks Kidd_ip,
I will check those one by one if I can.
See you later
