Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: Close Workbook Without Clipboard Message

  1. #1
    Join Date
    27th June 2004
    Location
    Atlanta, Georgia (USA)
    Posts
    164

    Close Workbook Without Clipboard Message

    When processing workbooks via VBA, on closing the workbook I sometimes get a request to respond to whether I want to save the clipboard.

    In the same way that there is the option to open a workbook without refreshing links

    VB:
     
    workbooks.open updatelinks:=False 
    
    
    I assume there is something on the order of:

    VB:
     
    workbook.close   DontSaveClipboard:=True 
    
    
    Question #1 is: What is the parameter syntax for saving or not saving the clipboard?

    Question #2 is: Where would I go to look up these parameter settings instead of having to come back to the group every time I find the next one I need?

    TIA,

    Far Farley

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    14th July 2007
    Posts
    759

    Re: Workbook Close - Don't Save Clipboard

    Just clear the clipboard first with
    VB:
    Application.CutCopyMode = False 
    
    

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    27th June 2004
    Location
    Atlanta, Georgia (USA)
    Posts
    164

    Re: Workbook Close - Don't Save Clipboard

    Turtle,

    Thanks. That's an innovative way to solve the issue.


    While that handles my specific issue, I also have my more generalized question. Do you know where to look up parameters, such as "updatelinks:=False" ?

    Far

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,708

    Re: Workbook Close - Don't Save Clipboard

    Errr, the VBA help is a good start!

    You can also use
    VB:
    Application.DisplayAlerts=False 
     'code
    Application.DisplayAlerts=True 
    
    
    depending your needs.

    BTW, please search BEFORE asking a question that has been answered hundreds of times.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Prevent Clipboard Message When Copying
    By stevekirk in forum EXCEL HELP
    Replies: 1
    Last Post: November 21st, 2007, 21:23
  2. Replies: 5
    Last Post: January 29th, 2007, 23:25
  3. Stop Data On Clipboard Message
    By Frank_ACN in forum EXCEL HELP
    Replies: 3
    Last Post: November 24th, 2006, 10:20
  4. Close Workbook Without Save Message or Prompt
    By Vargtass in forum EXCEL HELP
    Replies: 2
    Last Post: October 26th, 2006, 22:19
  5. How to close the Clipboard?
    By Andy in forum EXCEL HELP
    Replies: 2
    Last Post: January 6th, 2004, 13:38

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
  •  
porno