VBA code to notify a user that an Excel document has already been checked out if they attempt to edit it

I have a working, macro enabled Excel sheet on a SharePoint site for about 20 people to all use. I have it set so that it requires to be checked out in order to edit (So that only one person can edit at a time).

This has been working great, except some users of this file either ALWAYS forget to check the “check out and edit” option rather than “read only.” So they will make changes in “Read Only” mode, and end up saving a copy of it on their own computers (because it wasn’t checked out).

I was wondering if it were possible to make some sort of VBA event that checks to see if the document has been checked out of SharePoint before any changes are made, and if it hasn’t, it shows a message box telling them so that they may close it out and re-open in “checked out” mode.

Does it make sense to check a nonce on user log in?

I read the following blog post about implementing custom user log in:


In the post, the author walks through some PHP code for logging in a user via a form while checking a nonce.

My understanding is that nonces are used to prevent CSRF attacks — that is, to prevent logged in users from being tricked into taking some action without realizing it. But if the user is not logged in… Is the nonce accomplishing anything?

Do all non-logged-in users get the same nonce? I can’t think of how else they would be implemented. I guess a nonce could be useful if some imporant action is taken as a direct result of logging in… but if all guests visiting the login form get the same nonce, then a CSRF attack would still be trivial to execute, wouldn’t it?

I’m still learning about security stuff, and am finding this quite confusing.

How to measure phone number views without annoying the user?

I’m working on a website where we have customer pages on which we measure user interactions such as opening a booking form or posting a review.

One of the interactions we want to measure is when the users view phone numbers. Currently we do it like this:

Phone 123 – XXX XXX
show number

Show number is a button-link which shows the full number on click and allows us to track the user interaction.

We’ve recently had some feedback regarding the Xs in the phone number. Our users and customers find it confusing.

The customer information is displayed on one single page and tabs are not an option.

One alternative would be to only have the “show phone number button” without displaying the XXX-version of it.

Any other suggestions?

I’m also looking for good arguments to show the number directly (since, of course, that’s best for the user).

Is giving the user imprecise information good UX?

I noticed that YouTube now doesn’t show the exact number of views anymore, when the video has more than 1.000 views.

But instead of showing something abbreviated like 203k views, they show 203.000 views. Clearly rounded and in principle inaccurate.

I asked a similar question about YouTubes decision to not show the actual date of upload or “age” of a video, but rather showing imprecise representations like 1 year ago for a video, that was posted 1 year and 10 months ago: What is the advantage of using imprecise representations of time i. e. 'an hour ago'?

This latest change does not hide more accurate information so much as it pretends it isn’t available.

Is there any advantage to this, with reference to user experience or site usability? I personally really dislike this choice, because, while pretty much useless information in this example, it feels like I get a curated version of reality.

Gte SharePoint 2010 User Profile Data from User ID using CSOM PoweShell

I a wriiting a CSOM PowerShell for SharePoint 2010 in which I want to get get user details from the Person and Group field.

FieldUserValue returns only few properties (i.e. Email, LookupID, LookupValue, TypeID).

I tried to use Web.GetUserById method but it seems it is not available in SharePoint 2010 CSOM.

Anyone has any idea on how do I achieve this.

Below is my code :

if ($  SourceItem.FieldValues["Auth_x002d_Coordinator"] -ne $  null)  {                              $  userValue = [Microsoft.SharePoint.Client.FieldUserValue]$  SourceItem.FieldValues["Auth_x002d_Coordinator"]       $  ListItem["AuthCoordinator"] = $  userValue } 

Is there an unbiased way to collect feedback on a product idea in a user survey?

I’m working with a stakeholder on a potential major pivot to a product, which gets used both inside and outside our organization. The stakeholder wants to directly ask a question like this in a survey to internal potential users: “If our organization offered a way to (achieve your primary goal) (without either of your two top pain points), would you be interested in using it?”

I see this question as biased because it looks like “who in their right mind wouldn’t say yes?” The stakeholder has worked for us for many years and insists that this won’t be a problem, but I find this hard to believe.

Also, in our context, we have to consider whether or not our users have the time, capacity, and desire to use a product like ours. They can use it in or outside their jobs, but they don’t have to.

Are we out of line to ask a question like this? Even if we are, what is a less biased way to ask it?

User research survey & GDPR

I’m hoping to create and ask some user research surveys shortly and wanted to ask how people are treating the GDPR regulations in this area.

At a high level, I want to capture personally identifiable data (PID) to understand the demographics of the respondents. I’m aware I also need to get a signed acceptance to use their data.

I know that I’m under an obligation to remove PID both on request and when it’s not reasonably needed. Do people generally follow this and discard results? or do people tend to use the signed acceptance to override this?