Results 1 to 5 of 5

Thread: Allow only Copy cells and no other command.

  1. #1

    Allow only Copy cells and no other command.



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi All,

    I want the user of the spreadsheet to use only copy command on worksheet and no other command can be run. Please help how this can be done.

    Thanks
    Vishal

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,268
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    You want to protect the worksheet, but allow the user to select both locked and unlocked cells. At that point the user won't be able to edit anything, but they can still select the cells and copy them.

    In Excel 2003 and earlier, if I recall correctly, the command its under Tools-->Protection-->Protect Sheet
    In Excel 2007 and higher it is under Review-->Protect Sheet
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  3. #3

    Allow only Copy cells and no other command.

    Quote Originally Posted by Ken Puls View Post
    You want to protect the worksheet, but allow the user to select both locked and unlocked cells. At that point the user won't be able to edit anything, but they can still select the cells and copy them.

    In Excel 2003 and earlier, if I recall correctly, the command its under Tools-->Protection-->Protect Sheet
    In Excel 2007 and higher it is under Review-->Protect Sheet
    Dear Ken

    Thanks for the Reply, In My previous query i want to add one more condition. I want the user to use Copy command with Spin Control (Form Control)button .

    Thanks in advance
    Vishal
    Attached Files Attached Files

  4. #4
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,268
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Hmm... so you don't want the user to be able to change the value in C1 manually though, correct? You ONLY want them to be able to index that value up/down by using your spin button?
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  5. #5
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,268
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Hi Vishal,

    This issue with the Form control spin button is that the cell it is changing needs to be unprotected. I've re-worked your example with an ActiveX spin button. This workbook does use macros, and will fire every time the workbook is opened to protect all the worksheets in the workbook, but allow macros to make changes to the sheets.

    You will want to update the password in the "ThisWorkbook" code to something you'd want to use.
    Attached Files Attached Files
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

Posting Permissions

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