• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Prevent copy paste w/o a macro

vijehspaul

Member
Hi,

I have a workbook in which i need to disable copy/paste.

I got some macro codes to do that. but if i saved the workbook in .xlsx or .xls format, that wont work (expected).


So, is there any other way to prevent copy/paste ?


-Vijesh
 
Vijesh


You have to save the file as an Excel Macro (*.xlsm) or Binary (*.xlsb) file type for Macro's to be saved and available when the file is opened again
 
Hi, Vijesh!


Despite of that you should be aware that if you have any relevant code that runs at open time, if the user press shift key while opening the workbook the Auto Open macro isn't executed, even all other macros and event codes remain active. Just fyi.


Besides, you can do nothing if the user opens other workbook or creates a new worksheet, and simply types in A1 the formula ='[workbook.xlsm]worksheetname'!A1 and copies it across and down; maybe he can't steal the formulas but sure the values.


And digging a little deeper, with a short VBA snippet like this, he can get the formulas too:

-----

Sub X()

Dim I as Long, J as Integer

For I=1 To 100

For J=1 to 100

workbooks("workbook target").worksheets("worksheet target").cells(i,j).formula = workbooks("workbook source").worksheets("worksheet source").cells(i,j).formula

Next J

Next I

End Sub

-----

And say goodbye to 10000 cells content.


Hope it helps.


Regards!
 
<p> These models are fantastic towards the bit of skirt who likes to wear her fashion on her wrist as nicely as get the functionality she requires on the days when she is intense in her lavish time.The Michael Kors MK2227 women's chronograph is a rectangular formed scenario that is 36mm in elevation and 10mm brimming carried away from in a gold plated stainless metal with a champagne coloured dial pushed at hand quartz movement. The enquire about at liberty speaks of luxuriousness but is also up to date in that it has three sub-dials at two, 6 and ten o'clock, resplendent fingers, a pitch-black two shakes of a lamb's tail prints and gold spirit numerals.</p>


<p> </p>


<p>she has taken note of your friends or colleagues. But I think this is nonsense. Your friends will not explicitly told the stylist they havent learned your stuff. Colleagues in the same way, is quite small you know he has done in addition to your. Therefore, the possibility is very small, you only need to hear your bad project.</p>


<p> A good bag with extravagant quality leather and offered in numerous shades like brown, graphite, vanilla and patent leather. The chained straps are a well-behaved reminder from Chanel handbags and the strap horizontally laid at the prime vicinage of the tote is a traditional look back of the Hermes Birkin bag. Smaller, airy reminders of the iconic designers and their creations.With a monstrous flower of handbags from <span style="color: #ff6600">Michael Kors outlet</span>, there's no criticism to travel a fake handbag. Fake handbags backing terrorism, issue misapply, drug berate and so numerous additional horrific crimes. Aid worst the fake matter and lay out in fake inventor handbags only.Michael Kors ordain bring his hunch of class to a patronize levels with his women's chronographs. We on just take a glimpse at a few of them that be undergoing a satisfactory deal of first all in all fashion factors as properly as chronograph features.</p>


<p> </p>


<p>here is what should give you some helpful tips stylist when picking</p>


<p> </p>


<p>

New design and fashion appearance style michael kors handbags online hot selling.All love fashionable women should not miss this kind of new trend handbag,purse and wallet.Women and mens best choice.</p>


<p>In all of our options, the one of the most important to choose a designer. Why did the writers will to remain is it so? Due to this fact the stylist to generate your photos, people think of you when they meet with you. Good designer will help you one thing, or a person you want.</p>

<p>can ask the stylists address to find two options: you might ask a friend, relative or colleague stylist; 2. You may only be about a specific collision, use a good hair within the road, and require the designer tackles.</p>

<p> </p>


<p> The antiquated is shown at 4 thirty. A mineral lorgnon crystal protects the dial. An proper of the prodigious factors here this observe is the things colored leather strap that wraps two times all down the wrist providing it a speck of a jewelry experience. The sub-dial at 6 o'clock shows the date of the week future to the pass? window. Chrono pushers are completed in gold inflection on both side of the fluted government for a clear glimpse permitting leisure of operation. The timepiece is h2o opposed to fifty meters or 5 ATM.<span style="color: #ff6600">Michael Kors sale</span> models his watches based mostly on the developments of the year or so, they captivate fashion-driven clientele. This timepiece reflects a brilliance of intelligence and a peaceful route of living and is a consign of the Spring 2011 look at number that captures the foundation-stone of the Jet Put up lifestyle. Fashion discount michael kors tote bags design for women online.</p>


<p> </p>


<p>Sedu hairstyles are usually not only the style in the spring and summer of 2006, number one, they may be related to the ability of the designer is extremely demanding. So, if you want to have Sedu hairstyle, you should have the best hair stylist you will be able to get.</p>


<p>asked you like they have been given such a good hair style single. Therefore, individuals are often curious about entry noted that they are only too happy to share data.</p>


<p> </p>


<p> </p>


<p> His accomplishment resulted in the crack of more than 350 retailer openings in the Shared States.The recipient of a interest of noted awards in the performance of his specialty which includes, into the middle different other individuals, Author of the 10 years, Designer of the Appointment book year, Womenswear Deviser of the Yr and Menswear Inventor of the Year. He is also the youngest receiver to into the Geoffrey Beene Sentience go over Deed Grant from the CFDA.Michael Kors continues to prove his expertise as a profitable designer by constantly increasing his product or utility line with the most modern grouping of his of fragrances. An excellent artificer at an low-cost cost. <span style="color: #ff6600">Michael Kors bags</span> are a far-fetched particular to the greater conclusion handbags.Take the Hamilton Tote.</p>


<p>may be a piece of clothing, vehicle, or workplace. However, all the time we need to ensure that his own mistakes, May, Michael Kors handbags destroy our good temper, or health.</p>


<p> </p>


<p>In addition, a great designer is always the best fashion report, is to know all the latest trends. Therefore, you should be the right decision a designer, you will be in a position to get any hair type you want, including Sedu hairstyle, the best type.</p>

<p> 2012 new <span style="color: #ff6600">cheap michael kors purse sale</span>
http://http://www.michael-kors-bags-outlet.net/
http://http://www.michael-kors-bags-outlet.net/ for all of you.Most not long ago well known quest of his intention as a style infer on the enormous club Dernier cri Runway.Michael Kors took New York through rainstorm as a younger deviser for the boutique, Lothar's in Late-model York. With like peerless well-mannered results, he then established his private earmark in 1981. His signature patterns are chic, deluxe, and sporty. His aggregation grew to consist of adult females and guys collections which includes components, footwear, eyewear and handbags.</p>

<p> </p>


<p>Some people think that friends or colleagues who may provide you with false information in order to ensure that the designers will not slip you the secret, he</p>


<p> </p>


<p> </p>


<p>each of <span style="color: #ff6600">Michael Kors handbags</span>, we have contributed to pick some things in our lives. It</p>

 
Back
Top