Any vba code to protect sheet from copying or creating a shortcut

Lukma

New Member
Joined
Feb 12, 2020
Messages
33
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
HI guys

Firstly i am saying thanks to everyone in the forum, am glad to say my joining the forum has helped me a lot learning and improving on my skills on excel, a big thanks to you guys all.

My Question 1: is there any VBA code to protect my sheet so no one can copy or create a shortcut from a share folder.,
Question 2: is there any VBA that enable to edit and save but they wont be able to create a shortcut or copy or save in anywhere except in same folder sheet is.

If there any, I will be glad with a solution with the VBA code or any better from mine.

Regards
 

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Sharid

Well-known Member
Joined
Apr 22, 2007
Messages
1,047
Office Version
  1. 2016
Platform
  1. Windows
this migh help with the first question, but you will need to disable it after Link

As for the second, you might be able to do it via the File properties , not 100% sure , right click the file and look at properties and advance properties
 
Last edited:
Solution

Lukma

New Member
Joined
Feb 12, 2020
Messages
33
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
Dear Sharid

Thanks :biggrin:
 

Watch MrExcel Video

Forum statistics

Threads
1,127,308
Messages
5,623,890
Members
416,000
Latest member
Sovereign maphoso

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top