New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

How to disable copy/cut/paste protected workbook to another workbook

Macros, VBA, Excel Automation, etc.

How to disable copy/cut/paste protected workbook to another workbook

Postby kimbui » Thu Jul 07, 2016 4:05 am

Hello,

I run a VBA to simultaneously protected all worksheets in my workbook and successfully disable cut/copy/paste function in all its entirety. the problem is that when I send this version out, the receiver can still copy value of my file. I don't understand why. Please help.
  • 0

kimbui
Rookie
 
Posts: 1
Joined: Jul 7, 2016
Reputation: 0
Excel Version: 2010

Re: How to disable copy/cut/paste protected workbook to another workbook

Postby pecoflyer » Thu Jul 07, 2016 5:20 am

Hi and welcome
Perhaps post your code so we can look at it?
  • 0

A relevant topic title helps get faster and more answers
pecoflyer
Moderator
 
Posts: 1274
Joined: Jan 24, 2012
Location: Belgium
Reputation: 39
Excel Version: 2003/2007/2010


Return to Macros and VBA Questions

Who is online

Users browsing this forum: Google [Bot] and 7 guests

cron