Results 1 to 3 of 3

Thread: Close workbook without warning popup if the flie is read only

Thread Tools
Display
- Switch to Linear Mode
- Switch to Hybrid Mode
- Threaded Mode

Threaded View

Previous Post

Next Post

12-12-2011, 01:43 PM #2
Admin

View Profile

View Forum Posts

Private Message

Visit Homepage
Administrator

Join Date

Mar 2011

Posts

1,123

Rep Power

10
Hi Leo,

Replace

Code:

ActiveWindow.Close

with

Code:

ActiveWindow.Close 0
Cheers !

Excel Range to BBCode Table
Use Social Networking Tools If You Like the Answers !

Message to Cross Posters

@ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
Reply With Quote

Quick Navigation Excel Help Top

« Previous Thread | Next Thread »

Similar Threads

Macro To Close All CSV Files

By Howardc in forum Excel Help

Replies: 5
Last Post: 03-15-2014, 05:24 PM
Warning Alerts Depending On Time Remaining To Finish Task

By peter renton in forum Excel Help

Replies: 9
Last Post: 06-19-2013, 12:20 PM
Read/write very large xl2007 files

By Rasm in forum Excel Help

Replies: 3
Last Post: 04-07-2012, 05:28 AM
Timer to close excel workbook

By leopaulc in forum Excel Help

Replies: 5
Last Post: 10-24-2011, 12:31 PM
Copy Existing Sheet, Paste Values from existing workbook into new workbook

By crcline in forum Excel Help

Replies: 9
Last Post: 09-09-2011, 02:30 AM

Bookmarks

Bookmarks

Posting Permissions

You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
[VIDEO] code is On
HTML code is Off

All times are GMT +5. The time now is 08:55 PM.

Powered by vBulletin® Version 4.2.5
Copyright © 2026 vBulletin Solutions, Inc. All rights reserved.

ExcelFox is Not Associated With Microsoft®