excel vba - protect sheet so no copy/paste ability

  • Thread starter Thread starter chief
  • Start date Start date
C

chief

I have set up my sheet to protect using a password name login which the
runs the macros. It is set up so that the sheet's cells cannot b
edited, but the person can copy/paste the info onto another sheet.
This is a problem because there are hidden cells which contai
sensitive data. Any ideas
 
Hi, just a comment that i just found out, check out this
link that I was refered too. That password that you
setup doesn't do squat when you have access to this...
http://www.straxx.com/excel/password.html
I was mad when I saw this, when means nothing is really
safe unless you have a rookie looking at the spreadsheet.
THanks
Sean
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy & paste to protected sheet 3
How to enable Copy and Paste when the sheet and workbook is protected 1
Number Format Changes During VBA Copy/Paste 2
Protection on Worksheets 5
Macro & Protected sheet 2
Copy Sheet to new Sheet and clear cells on original sheets 7
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Cell in new sheet should always refer to defined cell in another s 8

Back
Top