+ Reply to Thread
Results 1 to 3 of 3

How to disable save and print button in excel worksheet 2010

  1. #1
    Registered User
    Join Date
    10-31-2012
    Location
    Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    2

    Smile How to disable save and print button in excel worksheet 2010

    hi Guys,

    I got 1 excel template that retrieve information real time from SQL server. to avoid information leaking, would like to find out is there anyway to disable the save and print button in excel ? appreciate your help.

    Chow

  2. #2
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: How to disable save and print button in excel worksheet 2010

    To prevent saving, try this code (Must be placed in the 'This Workbook' module):
    Please Login or Register  to view this content.
    -Moo

  3. #3
    Registered User
    Join Date
    10-31-2012
    Location
    Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: How to disable save and print button in excel worksheet 2010

    great, it works now. 1 more stuffs, how to disable user to perform cut and paste in excel worksheet ? i put in the code as follow, it only disable user to perform copy and paste, and NOT cut and paste ? so how ?

    Private Sub Workbook_Activate()
    Application.CutCopyMode = False
    Application.OnKey "^c", ""
    Application.CellDragAndDrop = False
    End Sub

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1