Breaking News: Grepper is joining You.com. Read the official announcement!

vba close workbook

1 Click QAT answered on December 14, 2022 Popularity 7/10 Helpfulness 5/10

answer vba close workbook

vba close workbook

Comment

Sub ExcelX_14_12_2022()
'Macro X for Excel to Close Active Window Excel file >> Add to QAT with "X" symbol
'SOURCE: jam61mar@gmail.com
'https://paypal.me/1ClickQAT?country.x=GB&locale.x=en_GB
ScreenUpdating = False

Dim ActiveWorkbook As Object
Dim ProtectedViewWindow As Object

'If a file is Protected View, Make it Editable
If Application.ProtectedViewWindows.Count > 0 Then
'if protected view file is not active window
On Error Resume Next
Application.ActiveProtectedViewWindow.Edit
End If

'If Macro X is pressed in error with no file in Open Excel App
On Error Resume Next
'If active window has a document close it
Application.ActiveWorkbook.Close

ScreenUpdating = True
Exit Sub
End Sub

Popularity 7/10 Helpfulness 5/10 Language vb

Source: Grepper

Tags: vba

Link to this answer
Share Copy Link

Contributed on Dec 14 2022

1 Click QAT

0 Answers Avg Quality 2/10

vba close workbook

Contents

More Related Answers

vba close workbook

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.