close syntax doesn't work in vba

Mohamad Alawamy 0 Reputation points
2023-09-01T22:25:30.44+00:00

close syntax with false dosen't work and still shoiwing me save prompt, and workbook still opened in vba projects

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,456 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Tanay Prasad 2,105 Reputation points
    2023-09-05T05:05:29.2366667+00:00

    Hi,

    It'd help a lot if you paste your code.

    But for the basics, here is the code you can verify-

    Workbooks("YourWorkbookName.xlsx").Close SaveChanges:=False
    
    
    0 comments No comments