It seems that you don't need VBA to achieve this. Format the range as text first and use "Protect Sheet" to stop users to provent users to change the formact.qp Cheng Tuesday, May 17, 2011 1:26 PM Hi everyone, I hope you can help. I have a spreadsheet that is used as part...
Get Cursor Postion in Access Text Box using VBA Get entire size (width and height) of a user control (including part hidden by scroll bar) Get Folder Name from BrowserDialog in WPF C# get icon of a site through a link Get Index of Item in ObservableCollection not working Get index positi...
Prompt users to save changes Prompted for username and password Query must have at least one destination field Reset an AutoNumber field value Reset page number on group level in a report Resolve database reference issues Resolve references in VBA Runtime error 2147319779 (8002801d) library not re...
VBAApplication VBApplication VBAssemblyInfoFile VBBDCModel VBBlankApplication VBBlankFile VBBlankPhone VBBlankWebSite VBClassCollection VBClassFile VBClassLibrary VBCloudBusinessApp VBCodTest VBColumn VBConsole VBConsoleTest VBContentType VBDatabaseLibrary VBDeploymentModule VBDeviceTest VBDynamicWebSite VBE...
This will let users select only YES in column A if the sum of columns B to F is positive, but it doesn't automatically change the value of column A to YES. If you want that, you'd need a bit of VBA code. KaylaStarr Enter YES and NO in two cells, e.g. in M1 and M2. ...
Man Fai Chan would only need to do the VBA route if people are purposefully change the template. I suspect it's more about users accidently editing it versus purposefully changing it which isn't hard to do. If it is on purpose then people are being very naughty!
MV Clouds is your trusted Salesforce development partner, specializing in AppExchange development, seamless integrations, and tailored cloud solutions. Empowering businesses with innovative and efficient workflows.
You could simply write VBA script to achieve the same result too. But still, using apex triggers gives much better control over things. Hope you enjoyed reading this post and welcome to learn more about best practices in SFDC. Feel free to share feedback via comments below. Thanks. ...
Explorer - Quick Access - How to set via group policy - but how to stop users from tampering with settings? Explorer closes automatically after a while Explorer crashes caused by twinui.appcore.dll when using Remote App Explorer not showing thumbnails on network drive. Explorer.exe Crashes Explor...
It's Time To Rethink Your Security for the AI Era April 28, 2025Read ➝ How AI and IoT are Supercharging the DDoS Threat April 21, 2025Watch ➝ Rethinking Cyber Defense with Zero Trust + AI April 14, 2025Read ➝ The New Frontier of Security Risk: AI-Generated Credentials ...