Restrict users from copying data

[Noone Important]

Is there anyway to restrict someone (maybe via vba) from copying the
contents of the spreadsheet into a new spreadsheet. I have a users that
protects his spreadsheets but others just copy the contents and create a new
worksheet and modify the numbers.

Thanks for any help in advance.

 

[Dave Peterson]

Not really. Excel isn't that kind of secure environment.

(any suggestion that involves a macro would be shot to bits if the user opened
the workbook with macros disabled)

 

[VILLABILLA]

Hi Paul,
I seem to have a similair situation. I have a sheet where a lot i
happening, but I needed to have a backup made onto another sheet wher
I save copies of that original sheet under each other.

In order to do this I made a 'between sheet' without merged cells bu
that shows the same info as the main sheet, next to that I kept al
columns and row of this between sheet the same sizes.

That between sheet is identical with the original sheet because the
are all linked cells but it doesn't have the merged cells an
differences in column and row sizes are standard. For this reason i
lookes maybe a bit less good then your original sheet but it makes i
possible to build that macro that you were trying.

This between sheet is hided all the time.

In the macro I made it unhide the between sheet, copies the data, the
the find function to look for "XXX", then past special/values, and hid
the between sheet after that.
In the between sheet I putted on the first cell of the last row XXX, i
that way the copies end up under each other on the backup sheet.
Of course you make sure that on your backup sheet, you have XXX type
in A1 when it is empty, after that it keeps pasting everything unde
each other...

I hope it is a solution as well for you..

 

[Paul Watkins]

Thanks
I'll give it a try.