What's the most efficient way to disable saving of fields with commas in an entire Excel file? One approach could be to use Data Validation, and the other could be to validate all fields using a macro when the file is being saved. Are there other ways? Which one is better and why?
Subscribe to:
Post Comments (Atom)
-
I have a KVM single core VPS optimized for hosting static content running only Nginx 1.13.8 with SSD and 1GB RAM with a hosting provider on ...
-
If I connect to a server with RDP and share my clipboard with the server, are there any security risks of my clipboard being availble to oth...
-
I have Sony Vaio laptop. I want to remap Left Control and Escape keys to Backslash () and Back-tick (`) keys respectively. I have already tr...
-
My question stems from the recent incident with CloudFlare on July 2nd deploying bad software on their systems and causing downtime to most ...
-
I'm trying to delete some registry keys (startup items) via the commandline and while I can delete from HKCU \SOFTWARE\Microsoft\Windows...
-
Issue: I'm having trouble with the Taskbar and Windows Explorer. I right-click on Notepad (that I've pinned to my "taskbar"...
-
I have a home server, with the following: My goal is to add drives to the server as needed to increase available space. When my case reache...
No comments:
Post a Comment