Hello everyone,
Is there any way where we can lock the template that our colleagues are using (even through VBA) such that if they use CTRL+A,C or V; excel will prompt that such action is not allowed?
Basically the objective is to restrict others from copying the template into another sheet since the file is accessible on the same computer.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
how about control + a?Originally Posted by alansidman
Based upon the link, I would assume
Did you even attempt this. It appears to be intuitive if the others worked,
Please Login or Register to view this content.
I did, but it won't work.. maybe because I'm using excel on mac..Based upon the link, I would assume
Did you even attempt this. It appears to be intuitive if the others worked,Please Login or Register to view this content.
that would have been nice to know from the onset. Please update your profile to reflect that. You are currently listed as using Office 2010 which is a Windows version.maybe because I'm using excel on mac.
I have no experience with MAC OS, so I will leave this for someone else to solve.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks