User Profile
Bkkendig
Copper Contributor
Joined 3 years ago
User Widgets
Recent Discussions
Search options for Microsoft list
I have multiple MS Lists established for internal clients. We use them for inventory control. Each list will contain no more than 4000 rows before we archive. I am looking for a good guide for users to learn the various search options. Any suggestions? Also interested in any special tips as I find the standard search and filtering do not always return expected results180Views0likes0CommentsExcel script to pause worksheet protection and allow data sort based on a specific column
I have a spreadsheet that is password protected. It contains a matrix of data (not formatted as a table), and the first row of the matrix contains data heading labels. The filter is turned on and any column can be filtered, even with protection turned on. My dilemma is I cannot sort the matrix while protection is turned on. Does anyone know a script that would pause protection, sort the matrix (alpha, ascending) based on a specific column, then resume protection?3.9KViews0likes3Comments- 1.4KViews0likes1Comment
Excel script to disable password / unprotect, then re-apply at end of script
I am using excel scripts. My challenge is to remove protection from a password protected worksheet, apply changes, then re-apply password protection. I'd be grateful for help with the portions of the script that disables the password, unprotects the worksheet, then later in the same script, re-applies the protection and re-applies the password.1.9KViews0likes3CommentsRe: Excel Script to Remove Carriage Returns
My next challenge is to remove protection from a password protected worksheet, apply changes, then re-apply password protection. Would you know the script that disables password/ unprotect, then later in same script, enable password/protects??3.5KViews0likes0Comments- 3.7KViews0likes2Comments
Excel Script to Remove Carriage Returns
I am trying to write an excel online script to remove carriage returns. Writing a macro to do this is in the desktop version of excel is easy via "cntl+j" using the replace drop down. However, I find that "cntl+j" is not working for me in the excel online environment. Any suggestions for how to write a script to remove carriage returns in excel online??Solved4KViews0likes4Comments
Recent Blog Articles
No content to show